2025-04-01 17:39:56 Using queries from '/repo/tests/queries' directory 2025-04-01 17:39:56 Connecting to ClickHouse server... OK 2025-04-01 17:39:56 Connected to server 24.12.2.20221.altinityantalya @ 82252d159dc02cab0f366aaa5691adc1545dd11d HEAD 2025-04-01 17:39:56 Found 1667 parallel tests and 130 sequential tests 2025-04-01 17:39:57 Running about 208 stateless tests (Process-8). 2025-04-01 17:39:57 03085_analyzer_alias_column_group_by: [ OK ] 0.58 sec. 2025-04-01 17:39:57 Running about 208 stateless tests (Process-10). 2025-04-01 17:39:57 01906_partition_by_multiply_by_zero: [ OK ] 0.73 sec. 2025-04-01 17:39:57 Running about 208 stateless tests (Process-6). 2025-04-01 17:39:57 03171_direct_dict_short_circuit_bug: [ OK ] 0.83 sec. 2025-04-01 17:39:57 01851_hedged_connections_external_tables: [ SKIPPED ] 0.00 sec. 2025-04-01 17:39:57 Reason: not running for current build 2025-04-01 17:39:57 Running about 208 stateless tests (Process-5). 2025-04-01 17:39:57 01010_pm_join_all_join_bug: [ OK ] 0.89 sec. 2025-04-01 17:39:57 Running about 208 stateless tests (Process-9). 2025-04-01 17:39:57 02724_persist_interval_type: [ OK ] 0.88 sec. 2025-04-01 17:39:57 Running about 208 stateless tests (Process-3). 2025-04-01 17:39:57 00228_shard_quantiles_deterministic_merge_overflow: [ OK ] 1.44 sec. 2025-04-01 17:39:58 02815_first_line: [ OK ] 0.68 sec. 2025-04-01 17:39:58 01549_low_cardinality_mv_fuzz: [ OK ] 0.68 sec. 2025-04-01 17:39:58 00251_has_types: [ OK ] 0.78 sec. 2025-04-01 17:39:58 02372_now_in_block: [ OK ] 1.18 sec. 2025-04-01 17:39:58 00820_multiple_joins_subquery_requires_alias: [ OK ] 1.13 sec. 2025-04-01 17:39:58 01914_ubsan_quantile_timing: [ OK ] 0.53 sec. 2025-04-01 17:39:58 02815_alias_to_length: [ OK ] 0.53 sec. 2025-04-01 17:39:58 00492_drop_temporary_table: [ OK ] 0.62 sec. 2025-04-01 17:39:59 00361_shared_array_offsets_and_squash_blocks: [ OK ] 0.73 sec. 2025-04-01 17:39:59 03230_subcolumns_mv: [ OK ] 0.73 sec. 2025-04-01 17:39:59 02465_limit_trivial_max_rows_to_read: [ OK ] 0.88 sec. 2025-04-01 17:40:00 Running about 208 stateless tests (Process-4). 2025-04-01 17:40:00 03230_keeper_cp_mv_commands: [ OK ] 3.49 sec. 2025-04-01 17:40:00 02723_param_exception_message_context: [ OK ] 2.13 sec. 2025-04-01 17:40:01 01043_h3_edge_length_m: [ OK ] 0.58 sec. 2025-04-01 17:40:01 00545_weird_aggregate_functions: [ OK ] 0.58 sec. 2025-04-01 17:40:02 01196_max_parser_depth: [ OK ] 2.63 sec. 2025-04-01 17:40:02 02352_interactive_queries_from_file: [ OK ] 2.13 sec. 2025-04-01 17:40:02 01436_storage_merge_with_join_push_down: [ OK ] 0.83 sec. 2025-04-01 17:40:02 Running about 208 stateless tests (Process-7). 2025-04-01 17:40:02 03031_minmax_index_for_pointinpolygon: [ OK ] 6.29 sec. 2025-04-01 17:40:02 00276_sample: [ OK ] 4.48 sec. 2025-04-01 17:40:03 02012_sha512_fixedstring: [ OK ] 0.63 sec. 2025-04-01 17:40:03 01036_union_different_columns: [ OK ] 0.68 sec. 2025-04-01 17:40:04 03285_analyzer_extract_common_expr_bug: [ OK ] 0.63 sec. 2025-04-01 17:40:04 02250_lots_of_columns_in_csv_with_names: [ OK ] 4.99 sec. 2025-04-01 17:40:05 03237_get_subcolumn_low_cardinality_column: [ OK ] 0.53 sec. 2025-04-01 17:40:05 02157_readonly_system_suspend: [ OK ] 1.98 sec. 2025-04-01 17:40:06 00122_join_with_subquery_with_subquery: [ OK ] 0.58 sec. 2025-04-01 17:40:06 01505_trivial_count_with_partition_predicate: [ OK ] 1.18 sec. 2025-04-01 17:40:06 03262_analyzer_materialized_view_in_with_cte: [ OK ] 0.73 sec. 2025-04-01 17:40:06 03198_unload_primary_key_outdated: [ OK ] 4.69 sec. 2025-04-01 17:40:07 00396_uuid: [ OK ] 0.73 sec. 2025-04-01 17:40:08 01949_heredoc_unfinished: [ OK ] 1.64 sec. 2025-04-01 17:40:08 01601_proxy_protocol: [ OK ] 1.48 sec. 2025-04-01 17:40:09 00365_statistics_in_formats: [ OK ] 5.04 sec. 2025-04-01 17:40:09 01214_test_storage_merge_aliases_with_where: [ OK ] 1.13 sec. 2025-04-01 17:40:10 02366_window_function_order_by: [ OK ] 0.68 sec. 2025-04-01 17:40:10 00271_agg_state_and_totals: [ OK ] 0.68 sec. 2025-04-01 17:40:10 03096_largest_triangle_3b_crash: [ OK ] 0.53 sec. 2025-04-01 17:40:11 03064_analyzer_named_subqueries: [ OK ] 0.58 sec. 2025-04-01 17:40:11 02158_proportions_ztest_cmp: [ OK ] 2.68 sec. 2025-04-01 17:40:11 01866_datetime64_cmp_with_constant: [ OK ] 1.08 sec. 2025-04-01 17:40:11 02843_backup_use_same_password_for_base_backup: [ OK ] 9.55 sec. 2025-04-01 17:40:11 03263_analyzer_materialized_view_cte_nested: [ OK ] 0.73 sec. 2025-04-01 17:40:13 02122_parallel_formatting_JSONCompactEachRowWithNames: [ OK ] 6.75 sec. 2025-04-01 17:40:14 02293_grouping_function_group_by: [ OK ] 2.54 sec. 2025-04-01 17:40:14 01851_clear_column_referenced_by_mv: [ OK ] 0.78 sec. 2025-04-01 17:40:14 00652_replicated_mutations_default_database_zookeeper: [ OK ] 3.69 sec. 2025-04-01 17:40:15 01416_join_totals_header_bug: [ OK ] 0.73 sec. 2025-04-01 17:40:15 01825_type_json_18: [ OK ] 0.64 sec. 2025-04-01 17:40:16 02538_alter_rename_sequence: [ OK ] 1.43 sec. 2025-04-01 17:40:18 01018_Distributed__shard_num: [ OK ] 2.39 sec. 2025-04-01 17:40:18 01289_min_execution_speed_not_too_early: [ OK ] 15.47 sec. 2025-04-01 17:40:18 00823_sequence_match_dfa: [ OK ] 6.40 sec. 2025-04-01 17:40:19 02515_and_or_if_multiif_not_return_lc: [ OK ] 0.57 sec. 2025-04-01 17:40:19 01769_extended_range_2: [ OK ] 0.83 sec. 2025-04-01 17:40:19 00050_any_left_join: [ OK ] 0.58 sec. 2025-04-01 17:40:19 03165_storage_merge_view_prewhere: [ OK ] 0.78 sec. 2025-04-01 17:40:20 03068_analyzer_distributed_join: [ OK ] 0.88 sec. 2025-04-01 17:40:21 02433_default_expression_operator_in: [ OK ] 1.08 sec. 2025-04-01 17:40:22 02861_alter_replace_partition_do_not_wait_mutations_on_unrelated_partitions: [ OK ] 7.09 sec. 2025-04-01 17:40:22 02932_group_by_null_fuzzer: [ OK ] 0.63 sec. 2025-04-01 17:40:22 00369_int_div_of_float: [ OK ] 0.58 sec. 2025-04-01 17:40:22 01455_nullable_type_with_if_agg_combinator: [ OK ] 0.58 sec. 2025-04-01 17:40:23 02916_replication_protocol_wait_for_part: [ OK ] 11.20 sec. 2025-04-01 17:40:23 01762_deltasumtimestamp: [ OK ] 0.73 sec. 2025-04-01 17:40:24 03033_dist_settings.optimize_skip_unused_shards_rewrite_in_composite_sharding_key: [ OK ] 0.78 sec. 2025-04-01 17:40:24 01273_arrow_nested_arrays_load: [ OK ] 4.58 sec. 2025-04-01 17:40:25 01303_polygons_equals: [ OK ] 0.63 sec. 2025-04-01 17:40:26 00969_columns_clause: [ OK ] 1.38 sec. 2025-04-01 17:40:26 00752_low_cardinality_permute: [ OK ] 0.89 sec. 2025-04-01 17:40:26 02516_projections_with_rollup: [ OK ] 28.20 sec. 2025-04-01 17:40:26 01921_with_fill_with_totals: [ OK ] 0.68 sec. 2025-04-01 17:40:27 02158_ztest: [ OK ] 0.70 sec. 2025-04-01 17:40:27 00900_orc_arrow_parquet_tuples: [ OK ] 9.30 sec. 2025-04-01 17:40:27 02723_jit_aggregation_bug_48120: [ OK ] 0.93 sec. 2025-04-01 17:40:28 00619_union_highlite: [ OK ] 0.79 sec. 2025-04-01 17:40:29 02534_parquet_fixed_binary_array: [ OK ] 6.19 sec. 2025-04-01 17:40:30 01045_array_zip: [ OK ] 1.24 sec. 2025-04-01 17:40:30 01477_lc_in_merge_join_left_key: [ OK ] 2.74 sec. 2025-04-01 17:40:31 01413_alter_update_supertype: [ OK ] 1.29 sec. 2025-04-01 17:40:32 02813_seriesDecomposeSTL: [ OK ] 1.75 sec. 2025-04-01 17:40:32 02024_compression_in_query: [ OK ] 6.82 sec. 2025-04-01 17:40:32 02985_if_over_big_int_decimal: [ OK ] 0.94 sec. 2025-04-01 17:40:33 00942_mv_rename_table: [ OK ] 0.84 sec. 2025-04-01 17:40:33 02113_untuple_func_alias: [ OK ] 0.59 sec. 2025-04-01 17:40:34 02030_function_mapContainsKeyLike: [ OK ] 1.12 sec. 2025-04-01 17:40:34 00007_array: [ OK ] 0.59 sec. 2025-04-01 17:40:35 02212_h3_get_pentagon_indexes: [ OK ] 1.09 sec. 2025-04-01 17:40:35 02129_add_column_add_ttl: [ OK ] 2.17 sec. 2025-04-01 17:40:36 03034_recursive_cte_tree: [ OK ] 0.89 sec. 2025-04-01 17:40:36 00723_remerge_sort: [ OK ] 8.70 sec. 2025-04-01 17:40:37 02733_sparse_columns_reload: [ OK ] 1.04 sec. 2025-04-01 17:40:37 00380_client_break_at_exception_in_batch_mode: [ OK ] 2.14 sec. 2025-04-01 17:40:38 02496_remove_redundant_sorting_analyzer: [ OK ] 22.09 sec. 2025-04-01 17:40:40 02952_clickhouse_local_query_parameters_cli: [ OK ] 1.98 sec. 2025-04-01 17:40:41 00700_to_decimal_or_something_1: [ OK ] 4.50 sec. 2025-04-01 17:40:42 02751_text_formats_bad_nullable_parsing: [ OK ] 5.55 sec. 2025-04-01 17:40:43 02135_local_create_db: [ OK ] 2.24 sec. 2025-04-01 17:40:44 02122_4letter_words_stress_zookeeper: [ OK ] 21.44 sec. 2025-04-01 17:40:44 01551_mergetree_read_in_order_spread: [ OK ] 0.88 sec. 2025-04-01 17:40:45 02870_per_column_settings: [ OK ] 1.23 sec. 2025-04-01 17:40:46 02316_hierarchical_dictionaries_nullable_parent_key: [ OK ] 1.93 sec. 2025-04-01 17:40:47 01062_pm_all_join_with_block_continuation: [ OK ] 48.31 sec. 2025-04-01 17:40:49 02498_random_string_in_json_schema_inference: [ OK ] 1.93 sec. 2025-04-01 17:40:52 02149_schema_inference_create_table_syntax: [ OK ] 9.80 sec. 2025-04-01 17:40:53 01499_log_deadlock: [ OK ] 0.74 sec. 2025-04-01 17:40:54 01655_plan_optimizations: [ OK ] 26.02 sec. 2025-04-01 17:40:54 00666_uniq_complex_types: [ OK ] 1.18 sec. 2025-04-01 17:40:55 02999_scalar_subqueries_bug_2: [ OK ] 0.58 sec. 2025-04-01 17:40:56 02540_date_column_consistent_insert_behaviour: [ OK ] 1.88 sec. 2025-04-01 17:40:56 02864_statistics_predicates: [ OK ] 11.27 sec. 2025-04-01 17:40:57 02295_GROUP_BY_AggregateFunction: [ OK ] 0.94 sec. 2025-04-01 17:40:57 00157_aliases_and_lambda_formal_parameters: [ OK ] 0.48 sec. 2025-04-01 17:40:58 01938_joins_identifiers: [ OK ] 0.73 sec. 2025-04-01 17:40:58 01505_pipeline_executor_UAF: [ OK ] 23.82 sec. 2025-04-01 17:40:59 02311_range_hashed_dictionary_range_cast: [ OK ] 0.69 sec. 2025-04-01 17:40:59 03036_reading_s3_archives: [ OK ] 2.39 sec. 2025-04-01 17:40:59 03046_column_in_block_array_join: [ OK ] 0.68 sec. 2025-04-01 17:40:59 00647_histogram: [ OK ] 0.68 sec. 2025-04-01 17:40:59 00581_limit_on_result_and_subquery_and_insert: [ OK ] 0.63 sec. 2025-04-01 17:40:59 02766_bitshift_with_const_arguments: [ OK ] 0.83 sec. 2025-04-01 17:41:00 03205_system_sync_replica_format: [ OK ] 0.58 sec. 2025-04-01 17:41:00 03071_analyzer_array_join_forbid_non_existing_columns: [ OK ] 0.79 sec. 2025-04-01 17:41:01 03162_dynamic_type_nested: [ OK ] 0.63 sec. 2025-04-01 17:41:01 01458_named_tuple_millin: [ OK ] 0.53 sec. 2025-04-01 17:41:01 03257_async_insert_native_empty_block: [ OK ] 6.69 sec. 2025-04-01 17:41:01 03224_json_merges_new_type_in_shared_data: [ OK ] 0.78 sec. 2025-04-01 17:41:01 03270_processors_profile_log_3: [ OK ] 12.41 sec. 2025-04-01 17:41:02 01010_partial_merge_join_const_and_lc: [ OK ] 0.78 sec. 2025-04-01 17:41:04 01780_column_sparse_full: [ OK ] 2.68 sec. 2025-04-01 17:41:04 01339_client_unrecognized_option: [ OK ] 2.34 sec. 2025-04-01 17:41:04 02020_cast_integer_overflow: [ OK ] 0.53 sec. 2025-04-01 17:41:04 00003_reinterpret_as_string: [ OK ] 0.53 sec. 2025-04-01 17:41:05 02294_dictionaries_hierarchical_index: [ OK ] 1.08 sec. 2025-04-01 17:41:06 01214_point_in_Mecca: [ OK ] 4.24 sec. 2025-04-01 17:41:06 02499_analyzer_set_index: [ OK ] 0.68 sec. 2025-04-01 17:41:07 01926_date_date_time_supertype: [ OK ] 0.68 sec. 2025-04-01 17:41:08 01825_type_json_missed_values: [ OK ] 1.18 sec. 2025-04-01 17:41:10 00339_parsing_bad_arrays: [ OK ] 1.48 sec. 2025-04-01 17:41:10 01098_msgpack_format: [ OK ] 29.96 sec. 2025-04-01 17:41:10 02896_leading_zeroes_no_octal: [ OK ] 4.33 sec. 2025-04-01 17:41:11 02513_prewhere_combine_step_filters: [ OK ] 1.13 sec. 2025-04-01 17:41:11 02508_index_analysis_to_date_timezone: [ OK ] 0.83 sec. 2025-04-01 17:41:11 00030_alter_table: [ OK ] 1.48 sec. 2025-04-01 17:41:12 02788_current_schemas_function: [ OK ] 0.88 sec. 2025-04-01 17:41:12 03024_total_rows_approx_is_set_for_system_zeros_and_generate_random: [ OK ] 0.73 sec. 2025-04-01 17:41:12 02864_statistics_delayed_materialization_in_merge: [ OK ] 1.08 sec. 2025-04-01 17:41:13 03243_array_join_lambda: [ OK ] 0.58 sec. 2025-04-01 17:41:13 03203_variant_convert_field_to_type_bug: [ OK ] 0.63 sec. 2025-04-01 17:41:13 03239_if_constant_folding: [ OK ] 0.74 sec. 2025-04-01 17:41:13 02534_join_prewhere_bug: [ OK ] 0.88 sec. 2025-04-01 17:41:14 01846_alter_column_without_type_bugfix: [ OK ] 0.68 sec. 2025-04-01 17:41:14 00552_logical_functions_uint8_as_bool: [ OK ] 0.68 sec. 2025-04-01 17:41:15 02324_map_combinator_bug: [ OK ] 1.13 sec. 2025-04-01 17:41:16 01710_projection_with_column_transformers: [ OK ] 0.53 sec. 2025-04-01 17:41:18 02572_query_views_log_background_thread: [ OK ] 18.18 sec. 2025-04-01 17:41:19 02789_functions_after_sorting_and_columns_with_same_names_bug: [ OK ] 1.03 sec. 2025-04-01 17:41:19 03230_async_insert_native: [ OK ] 4.89 sec. 2025-04-01 17:41:19 02472_segfault_expression_parser: [ OK ] 0.43 sec. 2025-04-01 17:41:20 02481_i43247_ubsan_in_minmaxany: [ OK ] 1.39 sec. 2025-04-01 17:41:21 02718_parquet_metadata_format: [ OK ] 5.01 sec. 2025-04-01 17:41:22 01188_attach_table_from_path: [ OK ] 1.13 sec. 2025-04-01 17:41:23 02715_or_null: [ OK ] 0.58 sec. 2025-04-01 17:41:23 02269_to_start_of_interval_overflow: [ OK ] 0.68 sec. 2025-04-01 17:41:24 02806_cte_block_cannot_be_empty: [ OK ] 0.64 sec. 2025-04-01 17:41:25 02246_flatten_tuple: [ OK ] 0.93 sec. 2025-04-01 17:41:30 02439_merge_selecting_partitions: [ OK ] 10.11 sec. 2025-04-01 17:41:36 01338_long_select_and_alter_zookeeper: [ OK ] 16.06 sec. 2025-04-01 17:41:38 00661_optimize_final_replicated_without_partition_zookeeper: [ OK ] 1.24 sec. 2025-04-01 17:41:38 02029_quantile_sanitizer: [ OK ] 0.73 sec. 2025-04-01 17:41:39 00552_or_nullable: [ OK ] 0.88 sec. 2025-04-01 17:41:41 03271_ghdata_object_to_json_alter: [ OK ] 63.87 sec. 2025-04-01 17:41:41 03174_least_greatest_ignore_null_input_values: [ OK ] 1.33 sec. 2025-04-01 17:41:41 02243_in_ip_address: [ OK ] 0.64 sec. 2025-04-01 17:41:42 03148_setting_max_streams_to_max_threads_ratio_overflow: [ OK ] 1.08 sec. 2025-04-01 17:41:45 01581_deduplicate_by_columns_local: [ OK ] 2.89 sec. 2025-04-01 17:41:45 02346_read_in_order_fixed_prefix: [ OK ] 40.92 sec. 2025-04-01 17:41:45 03271_decimal_monotonic_day_of_week: [ OK ] 0.63 sec. 2025-04-01 17:41:47 02574_suspicious_low_cardinality_msan: [ OK ] 1.28 sec. 2025-04-01 17:41:47 03268_system_parts_index_granularity: [ OK ] 0.54 sec. 2025-04-01 17:41:47 02956_clickhouse_local_system_parts: [ OK ] 2.23 sec. 2025-04-01 17:41:48 01710_query_log_with_projection_info: [ OK ] 6.20 sec. 2025-04-01 17:41:48 01802_toDateTime64_large_values: [ OK ] 0.68 sec. 2025-04-01 17:41:48 00700_decimal_in_keys: [ OK ] 1.08 sec. 2025-04-01 17:41:50 02791_final_block_structure_mismatch_bug: [ OK ] 1.88 sec. 2025-04-01 17:41:50 00411_long_accurate_number_comparison_int1: [ OK ] 64.04 sec. 2025-04-01 17:41:50 02680_default_star: [ OK ] 0.43 sec. 2025-04-01 17:41:50 01825_type_json_ghdata_insert_select: [ OK ] 47.89 sec. 2025-04-01 17:41:50 01423_if_nullable_cond: [ OK ] 0.54 sec. 2025-04-01 17:41:51 01544_file_engine_settings: [ OK ] 2.48 sec. 2025-04-01 17:41:51 02833_std_alias: [ OK ] 0.63 sec. 2025-04-01 17:41:51 02204_fractional_progress_bar_long: [ SKIPPED ] 0.00 sec. 2025-04-01 17:41:51 Reason: not running for current build 2025-04-01 17:41:51 00004_shard_format_ast_and_remote_table: [ OK ] 0.64 sec. 2025-04-01 17:41:51 00804_test_custom_compression_codes_log_storages: [ OK ] 2.33 sec. 2025-04-01 17:41:51 00730_unicode_terminal_format: [ OK ] 0.83 sec. 2025-04-01 17:41:52 02245_s3_virtual_columns: [ OK ] 0.93 sec. 2025-04-01 17:41:52 02566_analyzer_limit_settings_distributed: [ OK ] 0.98 sec. 2025-04-01 17:41:52 03237_max_map_state_decimal_serialization: [ OK ] 0.58 sec. 2025-04-01 17:41:52 00353_join_by_tuple: [ OK ] 0.53 sec. 2025-04-01 17:41:52 01354_tuple_low_cardinality_array_mapped_bug: [ OK ] 0.58 sec. 2025-04-01 17:41:53 02922_server_exit_code: [ OK ] 2.13 sec. 2025-04-01 17:41:54 02417_null_variadic_behaviour: [ OK ] 1.98 sec. 2025-04-01 17:41:55 01834_alias_columns_laziness_filimonov: [ OK ] 3.10 sec. 2025-04-01 17:41:56 01731_async_task_queue_wait: [ OK ] 3.24 sec. 2025-04-01 17:41:56 02097_polygon_dictionary_store_key: [ OK ] 0.98 sec. 2025-04-01 17:41:57 00002_system_numbers: [ OK ] 0.83 sec. 2025-04-01 17:41:57 03008_deduplication_insert_into_partitioned_table: [ OK ] 2.54 sec. 2025-04-01 17:41:57 02982_parallel_replicas_unexpected_cluster: [ OK ] 0.73 sec. 2025-04-01 17:41:58 01070_alter_with_ttl: [ OK ] 0.68 sec. 2025-04-01 17:41:58 02351_Map_combinator_dist: [ OK ] 1.29 sec. 2025-04-01 17:41:59 00520_http_nullable: [ OK ] 1.59 sec. 2025-04-01 17:41:59 00908_bloom_filter_index: [ OK ] 29.45 sec. 2025-04-01 17:41:59 03206_no_exceptions_clickhouse_local: [ FAIL ] 1.78 sec. 2025-04-01 17:41:59 Reason: return code: 134, result: 2025-04-01 17:41:59 2025-04-01 17:41:59 2025-04-01 17:41:59 2025-04-01 17:41:59 stdout: 2025-04-01 17:41:59 2025-04-01 17:41:59 2025-04-01 17:41:59 Settings used in the test: --max_insert_threads 2 --group_by_two_level_threshold 672595 --group_by_two_level_threshold_bytes 22049239 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 10871429 --max_read_buffer_size 994986 --prefer_localhost_replica 0 --max_block_size 90665 --max_joined_block_size_rows 93016 --max_threads 3 --optimize_append_index 1 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 1 --optimize_or_like_chain 1 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 21 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 10920486 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method mmap --remote_filesystem_read_method read --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 0 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 0 --remote_filesystem_read_prefetch 1 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 32Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 0 --compile_sort_description 1 --merge_tree_coarse_index_granularity 19 --optimize_distinct_in_order 1 --max_bytes_before_external_sort 0 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 787984612 --min_compress_block_size 1636648 --max_compress_block_size 2024248 --merge_tree_compact_parts_min_granules_to_multibuffer_read 13 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 8871796 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 3 --session_timezone Africa/Khartoum --use_page_cache_for_disks_without_file_cache False --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.36 --prefer_external_sort_block_bytes 100000000 --cross_join_min_rows_to_compress 100000000 --cross_join_min_bytes_to_compress 0 --min_external_table_block_size_bytes 1 --max_parsing_threads 10 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 1 --query_plan_join_swap_table false --output_format_native_write_json_as_string 1 --enable_vertical_final 0 2025-04-01 17:41:59 2025-04-01 17:41:59 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 2088974808 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 531140840 --index_granularity_bytes 7269453 --merge_max_block_size 6689 --index_granularity 58306 --min_bytes_for_wide_part 0 --marks_compress_block_size 45718 --primary_key_compress_block_size 81099 --replace_long_file_name_to_hash 0 --max_file_name_length 24 --min_bytes_for_full_part_storage 536870912 --compact_parts_max_bytes_to_buffer 35988816 --compact_parts_max_granules_to_buffer 120 --compact_parts_merge_max_bytes_to_prefetch_part 27544159 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 0 --old_parts_lifetime 10 --prewarm_mark_cache 1 --use_const_adaptive_granularity 0 --enable_index_granularity_compression 1 --use_primary_key_cache 0 --prewarm_primary_key_cache 1 2025-04-01 17:41:59 2025-04-01 17:41:59 Database: test_axigm1xv 2025-04-01 17:42:00 00558_aggregate_merge_totals_with_arenas: [ OK ] 0.58 sec. 2025-04-01 17:42:01 02525_different_engines_in_temporary_tables: [ OK ] 1.33 sec. 2025-04-01 17:42:01 01681_bloom_filter_nullable_column: [ OK ] 1.29 sec. 2025-04-01 17:42:03 00835_if_generic_case: [ OK ] 1.43 sec. 2025-04-01 17:42:03 02423_insert_stats_behaviour: [ OK ] 9.70 sec. 2025-04-01 17:42:03 02538_analyzer_create_table_as_select: [ OK ] 0.68 sec. 2025-04-01 17:42:04 03199_unbin_buffer_overflow: [ OK ] 13.56 sec. 2025-04-01 17:42:04 03003_prql_panic: [ OK ] 1.84 sec. 2025-04-01 17:42:04 01430_fix_any_rewrite_aliases: [ OK ] 0.53 sec. 2025-04-01 17:42:04 00143_number_classification_functions: [ OK ] 0.94 sec. 2025-04-01 17:42:05 03258_old_analyzer_const_expr_bug: [ OK ] 0.53 sec. 2025-04-01 17:42:05 03157_dynamic_type_json: [ OK ] 0.73 sec. 2025-04-01 17:42:05 00752_low_cardinality_lambda_argument: [ OK ] 1.03 sec. 2025-04-01 17:42:06 01825_new_type_json_bools: [ OK ] 0.70 sec. 2025-04-01 17:42:06 01891_partition_by_uuid: [ OK ] 0.64 sec. 2025-04-01 17:42:07 01414_freeze_does_not_prevent_alters: [ OK ] 1.12 sec. 2025-04-01 17:42:07 00506_union_distributed: [ OK ] 1.60 sec. 2025-04-01 17:42:08 01825_new_type_json_multiple_files: [ OK ] 8.45 sec. 2025-04-01 17:42:08 03166_optimize_row_order_during_insert: [ OK ] 1.23 sec. 2025-04-01 17:42:08 00299_stripe_log_multiple_inserts: [ OK ] 1.24 sec. 2025-04-01 17:42:08 00065_shard_float_literals_formatting: [ OK ] 0.68 sec. 2025-04-01 17:42:09 01620_fix_simple_state_arg_type: [ OK ] 0.89 sec. 2025-04-01 17:42:09 02981_variant_type_function: [ OK ] 1.33 sec. 2025-04-01 17:42:09 02811_invalid_embedded_rocksdb_create: [ OK ] 0.65 sec. 2025-04-01 17:42:10 02177_merge_optimize_aggregation_in_order: [ OK ] 0.84 sec. 2025-04-01 17:42:10 02012_compress_lz4: [ OK ] 2.33 sec. 2025-04-01 17:42:11 00809_add_days_segfault: [ OK ] 1.24 sec. 2025-04-01 17:42:11 02882_primary_key_index_in_function_different_types: [ OK ] 0.83 sec. 2025-04-01 17:42:12 00904_array_with_constant_2: [ OK ] 0.58 sec. 2025-04-01 17:42:12 03001_data_version_column: [ OK ] 0.94 sec. 2025-04-01 17:42:12 02477_exists_fuzz_43478: [ OK ] 0.58 sec. 2025-04-01 17:42:12 01493_table_function_null: [ OK ] 0.53 sec. 2025-04-01 17:42:13 00476_pretty_formats_and_widths: [ OK ] 0.63 sec. 2025-04-01 17:42:14 01085_simdjson_uint64: [ OK ] 0.59 sec. 2025-04-01 17:42:14 03032_storage_memory_modify_settings: [ OK ] 1.73 sec. 2025-04-01 17:42:15 03221_merge_profile_events: [ OK ] 14.16 sec. 2025-04-01 17:42:15 02718_cli_dashed_options_parsing: [ OK ] 4.95 sec. 2025-04-01 17:42:15 02752_space_function: [ OK ] 1.58 sec. 2025-04-01 17:42:15 03207_json_read_subcolumns_2_wide_merge_tree: [ SKIPPED ] 0.00 sec. 2025-04-01 17:42:15 Reason: not running for current build 2025-04-01 17:42:16 00974_full_outer_join: [ OK ] 0.70 sec. 2025-04-01 17:42:16 00098_f_union_all: [ OK ] 0.68 sec. 2025-04-01 17:42:17 03036_schema_inference_cache_s3_archives: [ OK ] 0.83 sec. 2025-04-01 17:42:17 03276_index_of_assume_sorted: [ OK ] 0.88 sec. 2025-04-01 17:42:17 01552_dict_fixedstring: [ OK ] 0.73 sec. 2025-04-01 17:42:18 01948_group_bitmap_and_or_xor_fix: [ OK ] 0.68 sec. 2025-04-01 17:42:18 00180_attach_materialized_view: [ OK ] 0.59 sec. 2025-04-01 17:42:18 02236_json_each_row_empty_map_schema_inference: [ OK ] 0.59 sec. 2025-04-01 17:42:19 03272_bad_aggregate_function: [ OK ] 0.73 sec. 2025-04-01 17:42:19 01825_new_type_json_9: [ OK ] 0.68 sec. 2025-04-01 17:42:19 02149_issue_32487: [ OK ] 0.53 sec. 2025-04-01 17:42:20 02680_illegal_type_of_filter_projection: [ OK ] 1.01 sec. 2025-04-01 17:42:21 02003_memory_limit_in_client: [ OK ] 69.11 sec. 2025-04-01 17:42:21 02491_part_log_has_table_uuid: [ OK ] 2.24 sec. 2025-04-01 17:42:22 02293_h3_hex_ring: [ OK ] 1.28 sec. 2025-04-01 17:42:22 03069_analyzer_with_alias_in_array_join: [ OK ] 0.60 sec. 2025-04-01 17:42:23 02474_extract_fixedstring_from_json: [ OK ] 1.28 sec. 2025-04-01 17:42:24 00914_replicate: [ OK ] 0.73 sec. 2025-04-01 17:42:35 02129_skip_quoted_fields: [ OK ] 20.19 sec. 2025-04-01 17:42:37 02562_native_tskv_default_for_omitted_fields: [ OK ] 12.54 sec. 2025-04-01 17:42:38 02346_fulltext_index_search: [ OK ] 40.30 sec. 2025-04-01 17:42:38 00831_quantile_weighted_parameter_check: [ OK ] 1.48 sec. 2025-04-01 17:42:38 00534_functions_bad_arguments8: [ SKIPPED ] 0.00 sec. 2025-04-01 17:42:38 Reason: not running for current build 2025-04-01 17:42:41 01077_mutations_index_consistency: [ OK ] 18.85 sec. 2025-04-01 17:42:41 02504_regexp_dictionary_ua_parser: [ OK ] 26.98 sec. 2025-04-01 17:42:43 01825_type_json_13: [ OK ] 7.05 sec. 2025-04-01 17:42:43 02842_largestTriangleThreeBuckets_aggregate_function: [ OK ] 4.38 sec. 2025-04-01 17:42:43 01034_unknown_qualified_column_in_join: [ OK ] 1.73 sec. 2025-04-01 17:42:46 00712_prewhere_with_final: [ OK ] 2.65 sec. 2025-04-01 17:42:46 02571_local_desc_abort_on_twitter_json: [ OK ] 2.94 sec. 2025-04-01 17:42:47 03009_format_show_database: [ OK ] 3.84 sec. 2025-04-01 17:42:47 00678_shard_funnel_window: [ OK ] 8.85 sec. 2025-04-01 17:42:49 00362_great_circle_distance: [ OK ] 1.40 sec. 2025-04-01 17:42:49 00568_empty_function_with_fixed_string: [ OK ] 1.58 sec. 2025-04-01 17:42:49 01273_arrow_stream: [ OK ] 41.63 sec. 2025-04-01 17:42:51 02841_not_ready_set_bug: [ OK ] 10.09 sec. 2025-04-01 17:42:53 02461_cancel_finish_race: [ OK ] 31.49 sec. 2025-04-01 17:42:53 02027_ngrams: [ OK ] 1.79 sec. 2025-04-01 17:42:53 02355_control_block_size_in_array_join: [ OK ] 3.83 sec. 2025-04-01 17:42:53 01890_state_of_state: [ OK ] 4.12 sec. 2025-04-01 17:42:53 02993_lazy_index_loading: [ OK ] 88.20 sec. 2025-04-01 17:42:54 02325_dates_schema_inference: [ OK ] 1.13 sec. 2025-04-01 17:42:54 01700_system_zookeeper_path_in: [ OK ] 0.83 sec. 2025-04-01 17:42:54 00460_vertical_and_totals_extremes: [ OK ] 0.59 sec. 2025-04-01 17:42:54 01784_parallel_formatting_memory: [ OK ] 1.08 sec. 2025-04-01 17:42:54 02932_query_settings_max_size_drop: [ OK ] 1.08 sec. 2025-04-01 17:42:54 02517_infer_uint64_in_case_of_int64_overflow: [ OK ] 8.70 sec. 2025-04-01 17:42:55 02567_native_type_conversions: [ OK ] 5.20 sec. 2025-04-01 17:42:55 03256_invalid_mutation_query: [ OK ] 1.08 sec. 2025-04-01 17:42:55 01845_add_testcase_for_arrayElement: [ OK ] 0.58 sec. 2025-04-01 17:42:56 01755_shard_pruning_with_literal: [ OK ] 0.63 sec. 2025-04-01 17:42:56 00712_prewhere_with_alias: [ OK ] 1.13 sec. 2025-04-01 17:42:56 01034_JSONCompactEachRow: [ OK ] 1.63 sec. 2025-04-01 17:42:56 01271_show_privileges: [ OK ] 0.53 sec. 2025-04-01 17:42:56 02751_protobuf_ipv6: [ OK ] 2.28 sec. 2025-04-01 17:42:59 02876_s3_cluster_schema_inference_names_with_spaces: [ OK ] 2.64 sec. 2025-04-01 17:42:59 02177_issue_31009: [ SKIPPED ] 0.00 sec. 2025-04-01 17:42:59 Reason: not running for current build 2025-04-01 17:42:59 02165_h3_edge_length_km: [ OK ] 3.00 sec. 2025-04-01 17:43:00 03281_dynamic_coalesce: [ OK ] 3.21 sec. 2025-04-01 17:43:01 01831_max_streams: [ OK ] 1.27 sec. 2025-04-01 17:43:02 01079_bit_operations_using_bitset: [ OK ] 2.45 sec. 2025-04-01 17:43:04 01940_totimezone_operator_monotonicity: [ OK ] 2.75 sec. 2025-04-01 17:43:06 02922_respect_nulls_Nullable: [ OK ] 5.81 sec. 2025-04-01 17:43:07 02479_analyzer_aggregation_crash: [ OK ] 2.00 sec. 2025-04-01 17:43:07 01660_join_or_all: [ OK ] 10.86 sec. 2025-04-01 17:43:08 03267_min_parts_to_merge_at_once: [ OK ] 13.43 sec. 2025-04-01 17:43:08 02883_zookeeper_finalize_stress: [ OK ] 12.56 sec. 2025-04-01 17:43:08 00853_join_with_nulls_crash: [ OK ] 2.08 sec. 2025-04-01 17:43:08 01683_dist_INSERT_block_structure_mismatch: [ OK ] 0.63 sec. 2025-04-01 17:43:09 01893_jit_aggregation_function_min_long: [ OK ] 7.05 sec. 2025-04-01 17:43:09 01079_alter_default_zookeeper_long: [ OK ] 2.19 sec. 2025-04-01 17:43:10 03279_pr_3_way_joins_left_first: [ OK ] 2.48 sec. 2025-04-01 17:43:12 01073_crlf_end_of_line: [ OK ] 1.25 sec. 2025-04-01 17:43:12 03208_array_of_json_read_subcolumns_2_compact_merge_tree: [ SKIPPED ] 0.00 sec. 2025-04-01 17:43:12 Reason: not running for current build 2025-04-01 17:43:13 02457_filesystem_function: [ OK ] 1.27 sec. 2025-04-01 17:43:15 01773_min_max_time_system_parts_datetime64: [ OK ] 1.45 sec. 2025-04-01 17:43:19 03038_recursive_cte_postgres_4: [ OK ] 3.42 sec. 2025-04-01 17:43:21 00938_dataset_test: [ OK ] 1.92 sec. 2025-04-01 17:43:24 03202_dynamic_null_map_subcolumn: [ OK ] 14.29 sec. 2025-04-01 17:43:25 00742_require_join_strictness: [ OK ] 3.74 sec. 2025-04-01 17:43:28 00975_json_hang: [ OK ] 19.26 sec. 2025-04-01 17:43:31 03199_queries_with_new_analyzer: [ OK ] 4.90 sec. 2025-04-01 17:43:32 02504_disallow_arrayjoin_in_mutations: [ OK ] 3.40 sec. 2025-04-01 17:43:32 03129_cte_with_final: [ OK ] 1.43 sec. 2025-04-01 17:43:33 00612_union_query_with_subquery: [ OK ] 1.07 sec. 2025-04-01 17:43:36 01463_resample_overflow: [ OK ] 2.96 sec. 2025-04-01 17:43:37 02125_lz4_compression_bug_JSONCompactEachRow: [ OK ] 42.98 sec. 2025-04-01 17:43:38 02163_operators: [ OK ] 1.27 sec. 2025-04-01 17:43:41 02255_broken_parts_chain_on_start: [ OK ] 15.26 sec. 2025-04-01 17:43:41 02366_kql_create_table: [ OK ] 2.71 sec. 2025-04-01 17:43:42 00503_cast_const_nullable: [ OK ] 0.59 sec. 2025-04-01 17:43:42 00991_system_parts_race_condition_long: [ OK ] 34.02 sec. 2025-04-01 17:43:42 02931_alter_materialized_view_query_inconsistent: [ OK ] 1.49 sec. 2025-04-01 17:43:43 01404_roundUpToPowerOfTwoOrZero_safety: [ OK ] 0.68 sec. 2025-04-01 17:43:43 01072_optimize_skip_unused_shards_const_expr_eval: [ OK ] 7.42 sec. 2025-04-01 17:43:43 01060_window_view_event_tumble_to_asc: [ OK ] 10.03 sec. 2025-04-01 17:43:44 00411_merge_tree_where_const_in_set: [ OK ] 0.78 sec. 2025-04-01 17:43:44 01753_mutate_table_predicated_with_table: [ OK ] 0.73 sec. 2025-04-01 17:43:45 02494_array_function_range: [ OK ] 0.68 sec. 2025-04-01 17:43:45 02176_toStartOfWeek_overflow_pruning: [ OK ] 0.83 sec. 2025-04-01 17:43:45 01621_clickhouse_compressor: [ OK ] 2.03 sec. 2025-04-01 17:43:45 01326_hostname_alias: [ OK ] 0.53 sec. 2025-04-01 17:43:46 01412_row_from_totals: [ OK ] 0.94 sec. 2025-04-01 17:43:47 01268_mv_scalars: [ OK ] 1.41 sec. 2025-04-01 17:43:48 01359_codeql: [ OK ] 0.48 sec. 2025-04-01 17:43:48 00814_parsing_ub: [ OK ] 0.53 sec. 2025-04-01 17:43:49 03246_json_simd_rapid_parsers: [ OK ] 3.44 sec. 2025-04-01 17:43:49 02815_range_dict_no_direct_join: [ OK ] 0.93 sec. 2025-04-01 17:43:50 03156_nullable_number_tips: [ OK ] 0.98 sec. 2025-04-01 17:43:50 02263_format_insert_settings: [ OK ] 8.20 sec. 2025-04-01 17:43:50 00358_from_string_complex_types: [ OK ] 0.53 sec. 2025-04-01 17:43:50 01460_line_as_string_format: [ OK ] 63.65 sec. 2025-04-01 17:43:51 02387_parse_date_as_datetime: [ OK ] 0.63 sec. 2025-04-01 17:43:51 01049_join_low_card_crash: [ OK ] 0.93 sec. 2025-04-01 17:43:51 01019_array_fill: [ OK ] 0.83 sec. 2025-04-01 17:43:51 00686_client_exit_code: [ OK ] 1.74 sec. 2025-04-01 17:43:52 00975_sample_prewhere_distributed: [ OK ] 0.73 sec. 2025-04-01 17:43:52 00296_url_parameters: [ OK ] 0.93 sec. 2025-04-01 17:43:53 01056_predicate_optimizer_bugs: [ OK ] 1.93 sec. 2025-04-01 17:43:54 02016_aggregation_spark_bar: [ OK ] 2.28 sec. 2025-04-01 17:43:55 02454_create_table_with_custom_disk: [ OK ] 1.14 sec. 2025-04-01 17:43:56 03234_check_grant: [ OK ] 4.59 sec. 2025-04-01 17:43:56 00623_truncate_table: [ OK ] 1.99 sec. 2025-04-01 17:43:57 03161_cnf_reduction: [ OK ] 1.73 sec. 2025-04-01 17:43:57 03150_infer_type_variant: [ OK ] 0.58 sec. 2025-04-01 17:43:58 00662_has_nullable: [ OK ] 0.83 sec. 2025-04-01 17:43:59 02122_parallel_formatting_TSV: [ OK ] 7.15 sec. 2025-04-01 17:44:00 01547_query_log_current_database: [ OK ] 4.29 sec. 2025-04-01 17:44:01 00417_kill_query: [ OK ] 5.30 sec. 2025-04-01 17:44:03 00926_adaptive_index_granularity_collapsing_merge_tree: [ OK ] 1.54 sec. 2025-04-01 17:44:04 00842_array_with_constant_overflow: [ OK ] 0.99 sec. 2025-04-01 17:44:06 02661_read_from_archive_tzst: [ OK ] 20.48 sec. 2025-04-01 17:44:06 01505_log_distributed_deadlock: [ OK ] 0.69 sec. 2025-04-01 17:44:07 01144_multiword_data_types: [ OK ] 0.79 sec. 2025-04-01 17:44:08 00351_select_distinct_arrays_tuples: [ OK ] 0.64 sec. 2025-04-01 17:44:09 03113_analyzer_not_found_column_in_block_2: [ OK ] 0.78 sec. 2025-04-01 17:44:10 03130_analyzer_self_join_group_by: [ OK ] 1.03 sec. 2025-04-01 17:44:10 01632_tinylog_read_write: [ OK ] 11.82 sec. 2025-04-01 17:44:11 02732_rename_after_processing: [ OK ] 6.65 sec. 2025-04-01 17:44:12 01702_rewrite_avg_for_algebraic_optimization: [ OK ] 1.03 sec. 2025-04-01 17:44:13 01272_suspicious_codecs: [ OK ] 2.99 sec. 2025-04-01 17:44:14 00338_replicate_array_of_strings: [ OK ] 1.04 sec. 2025-04-01 17:44:15 02271_replace_partition_many_tables: [ OK ] 31.51 sec. 2025-04-01 17:44:15 02235_add_part_offset_virtual_column: [ OK ] 15.67 sec. 2025-04-01 17:44:15 01440_big_int_shift: [ OK ] 0.68 sec. 2025-04-01 17:44:15 01640_distributed_async_insert_compression: [ OK ] 0.79 sec. 2025-04-01 17:44:16 00465_nullable_default: [ OK ] 0.65 sec. 2025-04-01 17:44:16 01837_cast_to_array_from_empty_array: [ OK ] 0.59 sec. 2025-04-01 17:44:16 02394_every_profile_event_must_have_documentation: [ OK ] 0.55 sec. 2025-04-01 17:44:17 00803_odbc_driver_2_format: [ OK ] 0.50 sec. 2025-04-01 17:44:17 00910_buffer_prewhere: [ OK ] 0.67 sec. 2025-04-01 17:44:18 01825_type_json_3: [ OK ] 2.79 sec. 2025-04-01 17:44:18 01276_system_licenses: [ OK ] 1.15 sec. 2025-04-01 17:44:18 00165_transform_non_const_default: [ OK ] 1.00 sec. 2025-04-01 17:44:19 01011_group_uniq_array_memsan: [ OK ] 0.61 sec. 2025-04-01 17:44:19 03013_position_const_start_pos: [ OK ] 0.53 sec. 2025-04-01 17:44:19 01720_engine_file_empty_if_not_exists: [ OK ] 1.55 sec. 2025-04-01 17:44:20 01038_dictionary_lifetime_min_zero_sec: [ OK ] 7.87 sec. 2025-04-01 17:44:20 01851_s2_to_geo: [ OK ] 0.59 sec. 2025-04-01 17:44:20 02902_select_subcolumns_from_engine_null: [ OK ] 0.65 sec. 2025-04-01 17:44:20 02206_clickhouse_local_use_database: [ OK ] 1.94 sec. 2025-04-01 17:44:21 02923_join_use_nulls_modulo: [ OK ] 0.95 sec. 2025-04-01 17:44:22 01790_dist_INSERT_block_structure_mismatch_types_and_names: [ OK ] 1.44 sec. 2025-04-01 17:44:23 02317_functions_with_nothing: [ OK ] 1.39 sec. 2025-04-01 17:44:24 01849_geoToS2: [ OK ] 2.36 sec. 2025-04-01 17:44:24 02475_or_function_alias_and_const_where: [ OK ] 0.63 sec. 2025-04-01 17:44:25 02967_fuzz_bad_cast: [ OK ] 1.19 sec. 2025-04-01 17:44:26 03084_analyzer_join_column_alias: [ OK ] 1.59 sec. 2025-04-01 17:44:26 01498_alter_column_storage_memory: [ OK ] 0.71 sec. 2025-04-01 17:44:26 00263_merge_aggregates_and_overflow: [ OK ] 1.15 sec. 2025-04-01 17:44:29 02813_seriesOutliersDetectTukey: [ OK ] 2.41 sec. 2025-04-01 17:44:29 01064_arrayROCAUC: [ OK ] 2.71 sec. 2025-04-01 17:44:31 00688_low_cardinality_syntax: [ OK ] 1.80 sec. 2025-04-01 17:44:31 01772_to_start_of_hour_align: [ OK ] 1.50 sec. 2025-04-01 17:44:32 02540_analyzer_matcher_alias_materialized_columns: [ OK ] 0.95 sec. 2025-04-01 17:44:32 00521_multidimensional: [ OK ] 1.39 sec. 2025-04-01 17:44:34 02990_format_select_from_explain: [ OK ] 1.43 sec. 2025-04-01 17:44:34 03273_group_by_in_order_still_used_when_group_by_key_doesnt_match_order_by_key: [ OK ] 2.04 sec. 2025-04-01 17:44:35 00751_low_cardinality_nullable_group_by: [ OK ] 34.38 sec. 2025-04-01 17:44:35 02245_s3_schema_desc: [ OK ] 1.18 sec. 2025-04-01 17:44:35 02933_group_by_memory_usage: [ OK ] 25.74 sec. 2025-04-01 17:44:36 02915_fpc_overflow: [ OK ] 1.84 sec. 2025-04-01 17:44:36 00950_test_gorilla_codec: [ OK ] 1.18 sec. 2025-04-01 17:44:36 01925_json_as_string_data_in_square_brackets: [ OK ] 0.64 sec. 2025-04-01 17:44:36 03227_dynamic_subcolumns_enumerate_streams: [ OK ] 0.63 sec. 2025-04-01 17:44:37 02354_with_statement_non_exist_column: [ OK ] 0.60 sec. 2025-04-01 17:44:37 02862_sorted_distinct_sparse_fix: [ OK ] 0.81 sec. 2025-04-01 17:44:37 01088_array_slice_of_aggregate_functions: [ OK ] 0.65 sec. 2025-04-01 17:44:37 02877_optimize_read_in_order_from_view: [ OK ] 17.49 sec. 2025-04-01 17:44:37 02455_extract_fixed_string_from_nested_json: [ OK ] 0.59 sec. 2025-04-01 17:44:37 01651_group_uniq_array_enum: [ OK ] 0.58 sec. 2025-04-01 17:44:38 02265_per_table_ttl_mutation_on_change: [ OK ] 1.39 sec. 2025-04-01 17:44:38 02963_single_value_destructor: [ OK ] 1.13 sec. 2025-04-01 17:44:38 01009_insert_select_data_loss: [ OK ] 0.63 sec. 2025-04-01 17:44:38 02476_fix_cast_parser_bug: [ OK ] 0.43 sec. 2025-04-01 17:44:38 00950_bad_alloc_when_truncate_join_storage: [ OK ] 0.48 sec. 2025-04-01 17:44:39 01259_datetime64_ubsan: [ OK ] 0.84 sec. 2025-04-01 17:44:39 02266_auto_add_nullable: [ OK ] 0.63 sec. 2025-04-01 17:44:39 01451_wrong_error_long_query: [ OK ] 1.78 sec. 2025-04-01 17:44:39 00284_external_aggregation_2: [ OK ] 91.78 sec. 2025-04-01 17:44:39 00609_distributed_with_case_when_then: [ OK ] 0.73 sec. 2025-04-01 17:44:39 03276_functions_to_subcolumns_lc: [ OK ] 0.63 sec. 2025-04-01 17:44:40 01906_bigint_accurate_cast_ubsan: [ OK ] 1.43 sec. 2025-04-01 17:44:41 02674_trivial_count_analyzer: [ OK ] 1.43 sec. 2025-04-01 17:44:41 02874_toDaysSinceYearZero: [ OK ] 1.92 sec. 2025-04-01 17:44:42 02002_system_table_with_tuple: [ OK ] 2.00 sec. 2025-04-01 17:44:42 00628_in_lambda_on_merge_table_bug: [ OK ] 0.88 sec. 2025-04-01 17:44:43 01714_alter_drop_version: [ OK ] 0.98 sec. 2025-04-01 17:44:44 01461_query_start_time_microseconds: [ OK ] 6.75 sec. 2025-04-01 17:44:44 02950_parallel_replicas_used_count: [ OK ] 24.20 sec. 2025-04-01 17:44:44 02943_variant_element: [ OK ] 0.78 sec. 2025-04-01 17:44:45 03043_group_array_result_is_expected: [ OK ] 0.63 sec. 2025-04-01 17:44:45 01690_quantilesTiming_ubsan: [ OK ] 0.48 sec. 2025-04-01 17:44:45 01081_demangle: [ OK ] 0.53 sec. 2025-04-01 17:44:45 00287_column_const_with_nan: [ OK ] 0.52 sec. 2025-04-01 17:44:45 01392_column_resolve: [ OK ] 0.68 sec. 2025-04-01 17:44:48 01825_new_type_json_11: [ OK ] 6.80 sec. 2025-04-01 17:44:49 00590_limit_by_column_removal: [ OK ] 0.58 sec. 2025-04-01 17:44:50 02908_Npy_files_caching: [ OK ] 4.69 sec. 2025-04-01 17:44:51 02276_full_sort_join_unsupported: [ OK ] 1.63 sec. 2025-04-01 17:44:51 01014_count_of_merges_metrics: [ OK ] 0.74 sec. 2025-04-01 17:44:51 02481_default_value_used_in_row_level_filter: [ OK ] 0.73 sec. 2025-04-01 17:44:52 02481_low_cardinality_with_short_circuit_functins: [ OK ] 0.83 sec. 2025-04-01 17:44:52 02946_literal_alias_misclassification: [ OK ] 0.63 sec. 2025-04-01 17:44:53 01055_prewhere_bugs: [ OK ] 0.83 sec. 2025-04-01 17:44:54 01646_rewrite_sum_if: [ OK ] 1.23 sec. 2025-04-01 17:44:57 02461_prewhere_row_level_policy_lightweight_delete: [ OK ] 4.94 sec. 2025-04-01 17:44:57 00844_join_lightee2: [ OK ] 0.78 sec. 2025-04-01 17:44:59 02225_hints_for_indeices: [ OK ] 4.39 sec. 2025-04-01 17:44:59 00647_select_numbers_with_offset: [ OK ] 0.53 sec. 2025-04-01 17:45:00 02971_limit_by_distributed: [ OK ] 0.83 sec. 2025-04-01 17:45:02 01520_client_print_query_id: [ OK ] 1.93 sec. 2025-04-01 17:45:03 00964_bloom_index_string_functions: [ OK ] 17.37 sec. 2025-04-01 17:45:03 00757_enum_defaults_const: [ OK ] 0.64 sec. 2025-04-01 17:45:04 01013_totals_without_aggregation: [ OK ] 0.89 sec. 2025-04-01 17:45:04 00875_join_right_nulls_ors: [ OK ] 1.03 sec. 2025-04-01 17:45:05 01880_remote_ipv6: [ OK ] 1.13 sec. 2025-04-01 17:45:05 01910_view_dictionary_check_refresh: [ OK ] 25.19 sec. 2025-04-01 17:45:05 02941_variant_type_2: [ OK ] 118.67 sec. 2025-04-01 17:45:05 02962_analyzer_constant_set: [ OK ] 0.58 sec. 2025-04-01 17:45:06 02366_kql_distinct: [ OK ] 0.73 sec. 2025-04-01 17:45:06 03007_column_nullable_uninitialzed_value: [ OK ] 0.53 sec. 2025-04-01 17:45:06 02711_trim_aliases: [ OK ] 0.63 sec. 2025-04-01 17:45:07 00668_compare_arrays_silviucpp: [ OK ] 0.58 sec. 2025-04-01 17:45:07 01328_bad_peephole_optimization: [ OK ] 0.53 sec. 2025-04-01 17:45:07 02711_server_uuid_macro: [ OK ] 1.03 sec. 2025-04-01 17:45:08 02337_join_analyze_stuck: [ OK ] 2.18 sec. 2025-04-01 17:45:08 02504_parse_datetime_best_effort_calebeaires: [ OK ] 0.58 sec. 2025-04-01 17:45:08 00072_in_types: [ OK ] 0.53 sec. 2025-04-01 17:45:09 01093_cyclic_defaults_filimonov: [ OK ] 0.68 sec. 2025-04-01 17:45:09 02931_size_virtual_column_use_structure_from_insertion_table: [ OK ] 1.83 sec. 2025-04-01 17:45:09 02418_keeper_map_keys_limit: [ OK ] 1.09 sec. 2025-04-01 17:45:10 00152_totals_in_subquery: [ OK ] 0.54 sec. 2025-04-01 17:45:10 01037_zookeeper_check_table_empty_pk: [ OK ] 0.83 sec. 2025-04-01 17:45:11 02243_make_date32: [ OK ] 1.98 sec. 2025-04-01 17:45:11 02999_analyzer_preimage_null: [ OK ] 0.63 sec. 2025-04-01 17:45:11 00340_squashing_insert_select: [ OK ] 32.61 sec. 2025-04-01 17:45:11 03001_bad_error_message_higher_order_functions: [ OK ] 2.08 sec. 2025-04-01 17:45:12 03199_fix_auc_tie_handling: [ OK ] 0.68 sec. 2025-04-01 17:45:13 02895_peak_memory_usage_http_headers_regression: [ OK ] 2.03 sec. 2025-04-01 17:45:14 01788_update_nested_type_subcolumn_check: [ OK ] 2.09 sec. 2025-04-01 17:45:14 02301_harmful_reexec: [ OK ] 2.33 sec. 2025-04-01 17:45:14 03156_group_concat: [ OK ] 2.68 sec. 2025-04-01 17:45:14 02049_lowcardinality_shortcircuit_crash: [ OK ] 0.68 sec. 2025-04-01 17:45:15 00802_daylight_saving_time_shift_backwards_at_midnight: [ OK ] 0.63 sec. 2025-04-01 17:45:15 01120_join_constants: [ OK ] 0.68 sec. 2025-04-01 17:45:16 01773_datetime64_add_ubsan: [ OK ] 0.78 sec. 2025-04-01 17:45:16 01821_join_table_mutation: [ OK ] 0.98 sec. 2025-04-01 17:45:16 01747_alter_partition_key_enum_zookeeper_long: [ OK ] 1.53 sec. 2025-04-01 17:45:16 01102_distributed_local_in_bug: [ OK ] 0.78 sec. 2025-04-01 17:45:17 01937_nested_chinese: [ OK ] 0.68 sec. 2025-04-01 17:45:17 03145_unicode_quotes: [ OK ] 0.58 sec. 2025-04-01 17:45:17 01122_totals_rollup_having_block_header: [ OK ] 0.58 sec. 2025-04-01 17:45:17 03033_final_undefined_last_mark: [ OK ] 0.44 sec. 2025-04-01 17:45:18 02150_replace_regexp_all_empty_match: [ OK ] 0.48 sec. 2025-04-01 17:45:18 00732_quorum_insert_simple_test_2_parts_zookeeper_long: [ OK ] 0.98 sec. 2025-04-01 17:45:18 02346_fulltext_index_bug47393: [ OK ] 0.78 sec. 2025-04-01 17:45:19 03233_dynamic_in_functions: [ OK ] 5.84 sec. 2025-04-01 17:45:19 00169_join_constant_keys: [ OK ] 0.95 sec. 2025-04-01 17:45:19 00534_functions_bad_arguments2: [ SKIPPED ] 0.00 sec. 2025-04-01 17:45:19 Reason: not running for current build 2025-04-01 17:45:20 02493_analyzer_sum_if_to_count_if: [ OK ] 1.13 sec. 2025-04-01 17:45:20 01720_union_distinct_with_limit: [ OK ] 0.58 sec. 2025-04-01 17:45:21 01419_merge_tree_settings_sanity_check: [ OK ] 1.08 sec. 2025-04-01 17:45:21 00217_shard_global_subquery_columns_with_same_name: [ OK ] 0.63 sec. 2025-04-01 17:45:21 03234_proto_complex_nested_repeated_noexception: [ OK ] 2.22 sec. 2025-04-01 17:45:22 03006_buffer_overflow_join: [ OK ] 0.58 sec. 2025-04-01 17:45:22 02985_minmax_index_aggregate_function: [ OK ] 0.98 sec. 2025-04-01 17:45:23 02591_bson_long_tuple: [ OK ] 0.58 sec. 2025-04-01 17:45:23 02473_multistep_split_prewhere: [ OK ] 38.07 sec. 2025-04-01 17:45:24 02764_index_analysis_fix: [ OK ] 0.63 sec. 2025-04-01 17:45:24 02226_low_cardinality_text_bloom_filter_index: [ OK ] 1.68 sec. 2025-04-01 17:45:25 01889_check_row_policy_defined_using_user_function: [ OK ] 9.16 sec. 2025-04-01 17:45:25 02112_delayed_clickhouse_client_with_queries_file: [ OK ] 2.08 sec. 2025-04-01 17:45:25 00758_array_reverse: [ OK ] 0.99 sec. 2025-04-01 17:45:26 01548_create_table_compound_column_format: [ OK ] 1.69 sec. 2025-04-01 17:45:28 00972_geohashesInBox: [ OK ] 3.94 sec. 2025-04-01 17:45:28 02128_apply_lambda_parsing: [ OK ] 0.59 sec. 2025-04-01 17:45:28 02461_alter_update_respect_part_column_type_bug: [ OK ] 3.64 sec. 2025-04-01 17:45:29 03040_dynamic_type_alters_1_wide_merge_tree: [ OK ] 2.70 sec. 2025-04-01 17:45:29 02810_fix_remove_dedundant_distinct_view: [ OK ] 0.94 sec. 2025-04-01 17:45:30 01892_setting_limit_offset_distributed: [ OK ] 0.99 sec. 2025-04-01 17:45:31 02150_index_hypothesis_race_long: [ OK ] 10.80 sec. 2025-04-01 17:45:31 01442_merge_detach_attach_long: [ OK ] 33.91 sec. 2025-04-01 17:45:32 02835_fuzz_remove_redundant_sorting: [ OK ] 2.24 sec. 2025-04-01 17:45:32 02884_duplicate_index_name: [ OK ] 0.58 sec. 2025-04-01 17:45:33 02316_cast_to_ip_address_default_column: [ OK ] 0.98 sec. 2025-04-01 17:45:33 01451_replicated_detach_drop_part_long: [ OK ] 2.04 sec. 2025-04-01 17:45:34 01280_unicode_whitespaces_lexer: [ OK ] 0.59 sec. 2025-04-01 17:45:35 02041_test_fuzzy_alter: [ OK ] 0.74 sec. 2025-04-01 17:45:35 01710_projection_optimize_group_by_function_keys: [ OK ] 0.68 sec. 2025-04-01 17:45:37 00100_subquery_table_identifier: [ OK ] 4.19 sec. 2025-04-01 17:45:42 01099_operators_date_and_timestamp: [ OK ] 6.09 sec. 2025-04-01 17:45:42 00953_constraints_operations: [ OK ] 10.50 sec. 2025-04-01 17:45:43 01580_column_const_comparision: [ OK ] 0.63 sec. 2025-04-01 17:45:43 01415_sticking_mutations: [ OK ] 39.42 sec. 2025-04-01 17:45:44 01021_only_tuple_columns: [ OK ] 2.24 sec. 2025-04-01 17:45:44 00726_length_aliases: [ OK ] 0.55 sec. 2025-04-01 17:45:45 03230_date_trunc_and_to_start_of_interval_on_date32: [ OK ] 1.50 sec. 2025-04-01 17:45:45 01199_url_functions_path_without_schema_yiurule: [ OK ] 0.58 sec. 2025-04-01 17:45:46 01880_materialized_view_to_table_type_check: [ OK ] 1.08 sec. 2025-04-01 17:45:46 03200_subcolumns_join_use_nulls: [ OK ] 0.79 sec. 2025-04-01 17:45:47 03152_analyzer_columns_list: [ OK ] 0.98 sec. 2025-04-01 17:45:47 01550_mutation_subquery: [ OK ] 0.68 sec. 2025-04-01 17:45:47 02477_age: [ OK ] 1.53 sec. 2025-04-01 17:45:48 03031_clickhouse_local_input: [ OK ] 4.64 sec. 2025-04-01 17:45:48 01085_extract_all_empty: [ OK ] 0.53 sec. 2025-04-01 17:45:49 00357_to_string_complex_types: [ OK ] 0.78 sec. 2025-04-01 17:45:49 03215_validate_type_in_alter_add_modify_column: [ OK ] 1.58 sec. 2025-04-01 17:45:50 00952_part_frozen_info: [ OK ] 0.89 sec. 2025-04-01 17:45:50 03062_analyzer_join_engine_missing_column: [ OK ] 0.68 sec. 2025-04-01 17:45:50 01663_quantile_weighted_overflow: [ OK ] 0.58 sec. 2025-04-01 17:45:51 03266_with_fill_staleness: [ OK ] 0.88 sec. 2025-04-01 17:45:51 01398_in_tuple_func: [ OK ] 0.69 sec. 2025-04-01 17:45:51 01710_projections_optimize_aggregation_in_order: [ OK ] 21.13 sec. 2025-04-01 17:45:52 00055_join_two_numbers: [ OK ] 0.63 sec. 2025-04-01 17:45:52 02267_insert_empty_data: [ OK ] 0.53 sec. 2025-04-01 17:45:53 03140_client_subsequent_external_tables: [ OK ] 1.93 sec. 2025-04-01 17:46:03 02841_join_filter_set_sparse: [ FAIL ] 1.08 sec. 2025-04-01 17:46:03 Reason: return code: 32 2025-04-01 17:46:03 Error on processing query: Code: 32. DB::Exception: Attempt to read after eof: while receiving packet from localhost:9000. (ATTEMPT_TO_READ_AFTER_EOF) (version 24.12.2.20221.altinityantalya (altinity build)) 2025-04-01 17:46:03 (query: SELECT countIf(ignore(*) == 0) FROM t1 JOIN t2 ON t1.s = t2.s;) 2025-04-01 17:46:03 , result: 2025-04-01 17:46:03 2025-04-01 17:46:03 2025-04-01 17:46:03 2025-04-01 17:46:03 stdout: 2025-04-01 17:46:03 2025-04-01 17:46:03 2025-04-01 17:46:03 Settings used in the test: --max_insert_threads 3 --group_by_two_level_threshold 482426 --group_by_two_level_threshold_bytes 50000000 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 21376022 --max_read_buffer_size 635170 --prefer_localhost_replica 0 --max_block_size 75845 --max_joined_block_size_rows 54219 --max_threads 2 --optimize_append_index 0 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 0 --optimize_or_like_chain 0 --optimize_substitute_columns 0 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 91 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 44115711 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 1 --min_bytes_to_use_mmap_io 1 --local_filesystem_read_method read --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 10 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 0 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 64Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 0 --compile_sort_description 0 --merge_tree_coarse_index_granularity 22 --optimize_distinct_in_order 1 --max_bytes_before_external_sort 0 --max_bytes_before_external_group_by 0 --max_bytes_before_remerge_sort 988381737 --min_compress_block_size 1817107 --max_compress_block_size 284446 --merge_tree_compact_parts_min_granules_to_multibuffer_read 49 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 7804188 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 3 --session_timezone Africa/Juba --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.3 --prefer_external_sort_block_bytes 1 --cross_join_min_rows_to_compress 100000000 --cross_join_min_bytes_to_compress 100000000 --min_external_table_block_size_bytes 1 --max_parsing_threads 1 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 0 --query_plan_join_swap_table true --output_format_native_write_json_as_string 1 --enable_vertical_final 0 2025-04-01 17:46:03 2025-04-01 17:46:03 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 6240349003 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 100 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 3664758498 --index_granularity_bytes 330795 --merge_max_block_size 19699 --index_granularity 11246 --min_bytes_for_wide_part 1073741824 --marks_compress_block_size 35030 --primary_key_compress_block_size 34332 --replace_long_file_name_to_hash 0 --max_file_name_length 55 --min_bytes_for_full_part_storage 0 --compact_parts_max_bytes_to_buffer 510861828 --compact_parts_max_granules_to_buffer 175 --compact_parts_merge_max_bytes_to_prefetch_part 12289243 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 35 --old_parts_lifetime 480 --prewarm_mark_cache 0 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 1 --use_primary_key_cache 1 --prewarm_primary_key_cache 0 2025-04-01 17:46:03 2025-04-01 17:46:03 Database: test_rnvzzqsk 2025-04-01 17:46:03 01671_aggregate_function_group_bitmap_data: [ FAIL ] 0.68 sec. 2025-04-01 17:46:03 Reason: return code: 210 2025-04-01 17:46:03 Code: 210. DB::NetException: Connection reset by peer, while reading from socket (peer: [::1]:9000, local: [::1]:58584): (localhost:9000, ::1, local address: [::1]:58584). (NETWORK_ERROR) 2025-04-01 17:46:03 2025-04-01 17:46:03 , result: 2025-04-01 17:46:03 2025-04-01 17:46:03 2025-04-01 17:46:03 2025-04-01 17:46:03 stdout: 2025-04-01 17:46:03 2025-04-01 17:46:03 2025-04-01 17:46:03 Settings used in the test: --max_insert_threads 2 --group_by_two_level_threshold 1 --group_by_two_level_threshold_bytes 50000000 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 12201714 --max_read_buffer_size 865507 --prefer_localhost_replica 0 --max_block_size 97703 --max_joined_block_size_rows 29130 --max_threads 3 --optimize_append_index 1 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 0 --optimize_or_like_chain 0 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 32 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 34195147 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 6725307069 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method io_uring --remote_filesystem_read_method read --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 1 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 64Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 8Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 1 --compile_sort_description 1 --merge_tree_coarse_index_granularity 22 --optimize_distinct_in_order 0 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 0 --max_bytes_before_remerge_sort 337055548 --min_compress_block_size 2434648 --max_compress_block_size 153032 --merge_tree_compact_parts_min_granules_to_multibuffer_read 8 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 1300899 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 0 --session_timezone Africa/Juba --use_page_cache_for_disks_without_file_cache False --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.57 --prefer_external_sort_block_bytes 1 --cross_join_min_rows_to_compress 100000000 --cross_join_min_bytes_to_compress 100000000 --min_external_table_block_size_bytes 1 --max_parsing_threads 10 --optimize_functions_to_subcolumns 1 --parallel_replicas_local_plan 0 --query_plan_join_swap_table auto --output_format_native_write_json_as_string 0 --enable_vertical_final 0 2025-04-01 17:46:03 2025-04-01 17:46:03 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 1 --vertical_merge_algorithm_min_rows_to_activate 1 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 10737418240 --index_granularity_bytes 5894704 --merge_max_block_size 3456 --index_granularity 6361 --min_bytes_for_wide_part 0 --marks_compress_block_size 38760 --primary_key_compress_block_size 61354 --replace_long_file_name_to_hash 1 --max_file_name_length 46 --min_bytes_for_full_part_storage 0 --compact_parts_max_bytes_to_buffer 28684583 --compact_parts_max_granules_to_buffer 253 --compact_parts_merge_max_bytes_to_prefetch_part 4049434 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 100 --old_parts_lifetime 480 --prewarm_mark_cache 1 --use_const_adaptive_granularity 0 --enable_index_granularity_compression 0 --use_primary_key_cache 0 --prewarm_primary_key_cache 0 2025-04-01 17:46:03 2025-04-01 17:46:03 Database: test_umfejymz 2025-04-01 17:46:03 01681_hyperscan_debug_assertion: [ FAIL ] 11.92 sec. 2025-04-01 17:46:03 Reason: server died 2025-04-01 17:46:03 ConnectionRefusedError 2025-04-01 17:46:03 [Errno 111] Connection refused 2025-04-01 17:46:03 File "/usr/bin/clickhouse-test", line 1854, in run 2025-04-01 17:46:03 self._cleanup(result.status == TestStatus.OK) 2025-04-01 17:46:03 2025-04-01 17:46:03 File "/usr/bin/clickhouse-test", line 1917, in _cleanup 2025-04-01 17:46:03 self._cleanup_database(args, timeout) 2025-04-01 17:46:03 2025-04-01 17:46:03 File "/usr/bin/clickhouse-test", line 1951, in _cleanup_database 2025-04-01 17:46:03 clickhouse_execute( 2025-04-01 17:46:03 2025-04-01 17:46:03 File "/usr/bin/clickhouse-test", line 334, in clickhouse_execute 2025-04-01 17:46:03 return clickhouse_execute_http( 2025-04-01 17:46:03 2025-04-01 17:46:03 File "/usr/bin/clickhouse-test", line 315, in clickhouse_execute_http 2025-04-01 17:46:03 raise ex 2025-04-01 17:46:03 2025-04-01 17:46:03 File "/usr/bin/clickhouse-test", line 304, in clickhouse_execute_http 2025-04-01 17:46:03 client.request( 2025-04-01 17:46:03 2025-04-01 17:46:03 File "/usr/lib/python3.10/http/client.py", line 1283, in request 2025-04-01 17:46:03 self._send_request(method, url, body, headers, encode_chunked) 2025-04-01 17:46:03 2025-04-01 17:46:03 File "/usr/lib/python3.10/http/client.py", line 1329, in _send_request 2025-04-01 17:46:03 self.endheaders(body, encode_chunked=encode_chunked) 2025-04-01 17:46:03 2025-04-01 17:46:03 File "/usr/lib/python3.10/http/client.py", line 1278, in endheaders 2025-04-01 17:46:03 self._send_output(message_body, encode_chunked=encode_chunked) 2025-04-01 17:46:03 2025-04-01 17:46:03 File "/usr/lib/python3.10/http/client.py", line 1038, in _send_output 2025-04-01 17:46:03 self.send(msg) 2025-04-01 17:46:03 2025-04-01 17:46:03 Settings used in the test: --max_insert_threads 2 --group_by_two_level_threshold 1000000 --group_by_two_level_threshold_bytes 8003255 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 12313890 --max_read_buffer_size 719803 --prefer_localhost_replica 0 --max_block_size 52379 --max_joined_block_size_rows 66586 --max_threads 3 --optimize_append_index 0 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 0 --optimize_or_like_chain 1 --optimize_substitute_columns 0 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 39 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 17533293 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method mmap --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 10 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 1 --allow_prefetched_read_pool_for_remote_filesystem 1 --filesystem_prefetch_max_memory_usage 128Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 100Mi --compile_aggregate_expressions 0 --compile_sort_description 1 --merge_tree_coarse_index_granularity 20 --optimize_distinct_in_order 1 --max_bytes_before_external_sort 0 --max_bytes_before_external_group_by 0 --max_bytes_before_remerge_sort 694971537 --min_compress_block_size 2979773 --max_compress_block_size 2457989 --merge_tree_compact_parts_min_granules_to_multibuffer_read 55 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 9866312 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 3 --session_timezone Mexico/BajaSur --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.83 --prefer_external_sort_block_bytes 1 --cross_join_min_rows_to_compress 0 --cross_join_min_bytes_to_compress 100000000 --min_external_table_block_size_bytes 0 --max_parsing_threads 0 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 1 --query_plan_join_swap_table true --output_format_native_write_json_as_string 0 --enable_vertical_final 0 2025-04-01 17:46:03 2025-04-01 17:46:03 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 3998079087 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 100 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 1 --index_granularity_bytes 31337897 --merge_max_block_size 3528 --index_granularity 42523 --min_bytes_for_wide_part 273598252 --marks_compress_block_size 50847 --primary_key_compress_block_size 47749 --replace_long_file_name_to_hash 1 --max_file_name_length 128 --min_bytes_for_full_part_storage 55418150 --compact_parts_max_bytes_to_buffer 450913845 --compact_parts_max_granules_to_buffer 168 --compact_parts_merge_max_bytes_to_prefetch_part 7133480 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 32 --old_parts_lifetime 10 --prewarm_mark_cache 0 --use_const_adaptive_granularity 0 --enable_index_granularity_compression 1 --use_primary_key_cache 1 --prewarm_primary_key_cache 0 2025-04-01 17:46:03 2025-04-01 17:46:03 Database: test_ofjicghs 2025-04-01 17:46:03 Process Process-9: 2025-04-01 17:46:03 Traceback (most recent call last): 2025-04-01 17:46:03 File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap 2025-04-01 17:46:03 self.run() 2025-04-01 17:46:03 File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run 2025-04-01 17:46:03 self._target(*self._args, **self._kwargs) 2025-04-01 17:46:03 File "/usr/bin/clickhouse-test", line 2626, in run_tests_process 2025-04-01 17:46:03 return run_tests_array(*args, **kwargs) 2025-04-01 17:46:03 File "/usr/bin/clickhouse-test", line 2407, in run_tests_array 2025-04-01 17:46:03 stop_tests() 2025-04-01 17:46:03 File "/usr/bin/clickhouse-test", line 452, in stop_tests 2025-04-01 17:46:03 cleanup_child_processes(os.getpid()) 2025-04-01 17:46:03 File "/usr/bin/clickhouse-test", line 440, in cleanup_child_processes 2025-04-01 17:46:03 child_pgid = os.getpgid(child) 2025-04-01 17:46:03 ProcessLookupError: [Errno 3] No such process 2025-04-01 17:46:03 Child processes of 1396: 2025-04-01 17:46:03 41785 /bin/sh -c pgrep --parent 1396 -a 2025-04-01 17:46:04 02844_max_backup_bandwidth_s3: [ FAIL ] 6.00 sec. 2025-04-01 17:46:04 Reason: return code: 210 2025-04-01 17:46:04 Error on processing query: Code: 32. DB::Exception: Attempt to read after eof: while receiving packet from localhost:9000. (ATTEMPT_TO_READ_AFTER_EOF) (version 24.12.2.20221.altinityantalya (altinity build)) 2025-04-01 17:46:04 (query: SYSTEM FLUSH LOGS;) 2025-04-01 17:46:04 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-01 17:46:04 2025-04-01 17:46:04 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-01 17:46:04 2025-04-01 17:46:04 , result: 2025-04-01 17:46:04 2025-04-01 17:46:04 2025-04-01 17:46:04 2025-04-01 17:46:04 stdout: 2025-04-01 17:46:04 2025-04-01 17:46:04 2025-04-01 17:46:04 Settings used in the test: --max_insert_threads 2 --group_by_two_level_threshold 741683 --group_by_two_level_threshold_bytes 47159360 --distributed_aggregation_memory_efficient 1 --fsync_metadata 1 --output_format_parallel_formatting 0 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 12317057 --max_read_buffer_size 754288 --prefer_localhost_replica 1 --max_block_size 36740 --max_joined_block_size_rows 98736 --max_threads 1 --optimize_append_index 1 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 1 --optimize_or_like_chain 1 --optimize_substitute_columns 0 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 25 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 36192420 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 6541293247 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method pread_threadpool --remote_filesystem_read_method read --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 50 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 128Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 1 --compile_sort_description 1 --merge_tree_coarse_index_granularity 21 --optimize_distinct_in_order 1 --max_bytes_before_external_sort 5244846134 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 1189983565 --min_compress_block_size 3063502 --max_compress_block_size 1838624 --merge_tree_compact_parts_min_granules_to_multibuffer_read 42 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 8139777 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 3 --session_timezone Mexico/BajaSur --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.65 --prefer_external_sort_block_bytes 1 --cross_join_min_rows_to_compress 0 --cross_join_min_bytes_to_compress 0 --min_external_table_block_size_bytes 1 --max_parsing_threads 1 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 1 --query_plan_join_swap_table auto --output_format_native_write_json_as_string 1 --enable_vertical_final 1 2025-04-01 17:46:04 2025-04-01 17:46:04 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 3438478178 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 10737418240 --index_granularity_bytes 17218000 --merge_max_block_size 4659 --index_granularity 39897 --min_bytes_for_wide_part 1073741824 --marks_compress_block_size 69552 --primary_key_compress_block_size 91799 --replace_long_file_name_to_hash 0 --max_file_name_length 128 --min_bytes_for_full_part_storage 342185656 --compact_parts_max_bytes_to_buffer 263592454 --compact_parts_max_granules_to_buffer 1 --compact_parts_merge_max_bytes_to_prefetch_part 6838531 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 1 --old_parts_lifetime 222 --prewarm_mark_cache 0 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 1 --use_primary_key_cache 1 --prewarm_primary_key_cache 1 2025-04-01 17:46:04 2025-04-01 17:46:04 Database: test_89ntz7bn 2025-04-01 17:46:04 01903_correct_block_size_prediction_with_default: [ FAIL ] 73.22 sec. 2025-04-01 17:46:04 Reason: return code: 210 2025-04-01 17:46:04 Error on processing query: Code: 32. DB::Exception: Attempt to read after eof: while receiving packet from localhost:9000. (ATTEMPT_TO_READ_AFTER_EOF) (version 24.12.2.20221.altinityantalya (altinity build)) 2025-04-01 17:46:04 (query: SELECT uniq(15Id) FROM test_extract PREWHERE 15Id < 4 SETTINGS max_threads=1) 2025-04-01 17:46:04 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-01 17:46:04 2025-04-01 17:46:04 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-01 17:46:04 2025-04-01 17:46:04 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-01 17:46:04 2025-04-01 17:46:04 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-01 17:46:04 2025-04-01 17:46:04 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-01 17:46:04 2025-04-01 17:46:04 , result: 2025-04-01 17:46:04 2025-04-01 17:46:04 8 2025-04-01 17:46:04 8 2025-04-01 17:46:04 1 2025-04-01 17:46:04 2025-04-01 17:46:04 stdout: 2025-04-01 17:46:04 8 2025-04-01 17:46:04 8 2025-04-01 17:46:04 1 2025-04-01 17:46:04 2025-04-01 17:46:04 2025-04-01 17:46:04 2025-04-01 17:46:04 Database: test_ofr5rq7t 2025-04-01 17:46:05 03036_test_parquet_bloom_filter_push_down: [ FAIL ] 17.84 sec. 2025-04-01 17:46:05 Reason: having stderror: 2025-04-01 17:46:05 Code: 210. DB::NetException: Connection reset by peer, while reading from socket (peer: [::1]:9000, local: [::1]:58606): (localhost:9000, ::1, local address: [::1]:58606). (NETWORK_ERROR) 2025-04-01 17:46:05 2025-04-01 17:46:05 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-01 17:46:05 2025-04-01 17:46:05 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-01 17:46:05 2025-04-01 17:46:05 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-01 17:46:05 2025-04-01 17:46:05 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-01 17:46:05 2025-04-01 17:46:05 2025-04-01 17:46:05 stdout: 2025-04-01 17:46:05 1000 2025-04-01 17:46:05 bloom filter is off, all row groups should be read 2025-04-01 17:46:05 expect rows_read = select count() 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "data": [ 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "string": "AZSR", 2025-04-01 17:46:05 "flba": "WNMM" 2025-04-01 17:46:05 }, 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "string": "PFJH", 2025-04-01 17:46:05 "flba": "GKJC" 2025-04-01 17:46:05 } 2025-04-01 17:46:05 ], 2025-04-01 17:46:05 "rows": 2, 2025-04-01 17:46:05 "statistics": { 2025-04-01 17:46:05 "rows_read": 1000, 2025-04-01 17:46:05 "bytes_read": 47419 2025-04-01 17:46:05 } 2025-04-01 17:46:05 } 2025-04-01 17:46:05 bloom filter is on, some row groups should be skipped 2025-04-01 17:46:05 expect rows_read much less than select count() 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "data": [ 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "string": "AZSR", 2025-04-01 17:46:05 "flba": "WNMM" 2025-04-01 17:46:05 }, 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "string": "PFJH", 2025-04-01 17:46:05 "flba": "GKJC" 2025-04-01 17:46:05 } 2025-04-01 17:46:05 ], 2025-04-01 17:46:05 "rows": 2, 2025-04-01 17:46:05 "statistics": { 2025-04-01 17:46:05 "rows_read": 464, 2025-04-01 17:46:05 "bytes_read": 21703 2025-04-01 17:46:05 } 2025-04-01 17:46:05 } 2025-04-01 17:46:05 bloom filter is on, but where predicate contains data from 2 row groups out of 3. 2025-04-01 17:46:05 Rows read should be less than select count, but greater than previous selects 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "data": [ 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "string": "PFJH", 2025-04-01 17:46:05 "flba": "GKJC" 2025-04-01 17:46:05 }, 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "string": "ZHZK", 2025-04-01 17:46:05 "flba": "HRWD" 2025-04-01 17:46:05 } 2025-04-01 17:46:05 ], 2025-04-01 17:46:05 "rows": 2, 2025-04-01 17:46:05 "statistics": { 2025-04-01 17:46:05 "rows_read": 536, 2025-04-01 17:46:05 "bytes_read": 25708 2025-04-01 17:46:05 } 2025-04-01 17:46:05 } 2025-04-01 17:46:05 bloom filter is on, but where predicate contains data from all row groups 2025-04-01 17:46:05 expect rows_read = select count() 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "data": [ 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "string": "PFJH", 2025-04-01 17:46:05 "flba": "GKJC" 2025-04-01 17:46:05 }, 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "string": "OKAI", 2025-04-01 17:46:05 "flba": "UXGT" 2025-04-01 17:46:05 }, 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "string": "ZHZK", 2025-04-01 17:46:05 "flba": "HRWD" 2025-04-01 17:46:05 } 2025-04-01 17:46:05 ], 2025-04-01 17:46:05 "rows": 3, 2025-04-01 17:46:05 "statistics": { 2025-04-01 17:46:05 "rows_read": 1000, 2025-04-01 17:46:05 "bytes_read": 47419 2025-04-01 17:46:05 } 2025-04-01 17:46:05 } 2025-04-01 17:46:05 IN check 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "data": [ 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "string": "PFJH", 2025-04-01 17:46:05 "flba": "GKJC" 2025-04-01 17:46:05 }, 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "string": "ZHZK", 2025-04-01 17:46:05 "flba": "HRWD" 2025-04-01 17:46:05 } 2025-04-01 17:46:05 ], 2025-04-01 17:46:05 "rows": 2, 2025-04-01 17:46:05 "statistics": { 2025-04-01 17:46:05 "rows_read": 536, 2025-04-01 17:46:05 "bytes_read": 25708 2025-04-01 17:46:05 } 2025-04-01 17:46:05 } 2025-04-01 17:46:05 tuple in case, bf is off. 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "data": [ 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "string": "PFJH", 2025-04-01 17:46:05 "flba": "GKJC" 2025-04-01 17:46:05 } 2025-04-01 17:46:05 ], 2025-04-01 17:46:05 "rows": 1, 2025-04-01 17:46:05 "statistics": { 2025-04-01 17:46:05 "rows_read": 1000, 2025-04-01 17:46:05 "bytes_read": 47419 2025-04-01 17:46:05 } 2025-04-01 17:46:05 } 2025-04-01 17:46:05 tuple in case, bf is on. 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "data": [ 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "string": "PFJH", 2025-04-01 17:46:05 "flba": "GKJC" 2025-04-01 17:46:05 } 2025-04-01 17:46:05 ], 2025-04-01 17:46:05 "rows": 1, 2025-04-01 17:46:05 "statistics": { 2025-04-01 17:46:05 "rows_read": 464, 2025-04-01 17:46:05 "bytes_read": 21703 2025-04-01 17:46:05 } 2025-04-01 17:46:05 } 2025-04-01 17:46:05 complex tuple in case, bf is off 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "data": [ 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "string": "PFJH", 2025-04-01 17:46:05 "flba": "GKJC" 2025-04-01 17:46:05 } 2025-04-01 17:46:05 ], 2025-04-01 17:46:05 "rows": 1, 2025-04-01 17:46:05 "statistics": { 2025-04-01 17:46:05 "rows_read": 1000, 2025-04-01 17:46:05 "bytes_read": 47419 2025-04-01 17:46:05 } 2025-04-01 17:46:05 } 2025-04-01 17:46:05 complex tuple in case, bf is on 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "data": [ 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "string": "PFJH", 2025-04-01 17:46:05 "flba": "GKJC" 2025-04-01 17:46:05 } 2025-04-01 17:46:05 ], 2025-04-01 17:46:05 "rows": 1, 2025-04-01 17:46:05 "statistics": { 2025-04-01 17:46:05 "rows_read": 464, 2025-04-01 17:46:05 "bytes_read": 21703 2025-04-01 17:46:05 } 2025-04-01 17:46:05 } 2025-04-01 17:46:05 complex tuple in case, bf is on. Non existent 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "data": [], 2025-04-01 17:46:05 "rows": 0, 2025-04-01 17:46:05 "statistics": { 2025-04-01 17:46:05 "rows_read": 0, 2025-04-01 17:46:05 "bytes_read": 0 2025-04-01 17:46:05 } 2025-04-01 17:46:05 } 2025-04-01 17:46:05 Bloom filter for json column. BF is off 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "data": [ 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "json": "{\"key\":38, \"value\":\"NXONM\"}" 2025-04-01 17:46:05 } 2025-04-01 17:46:05 ], 2025-04-01 17:46:05 "rows": 1, 2025-04-01 17:46:05 "statistics": { 2025-04-01 17:46:05 "rows_read": 1000, 2025-04-01 17:46:05 "bytes_read": 47419 2025-04-01 17:46:05 } 2025-04-01 17:46:05 } 2025-04-01 17:46:05 Bloom filter for json column. BF is on 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "data": [ 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "json": "{\"key\":38, \"value\":\"NXONM\"}" 2025-04-01 17:46:05 } 2025-04-01 17:46:05 ], 2025-04-01 17:46:05 "rows": 1, 2025-04-01 17:46:05 "statistics": { 2025-04-01 17:46:05 "rows_read": 72, 2025-04-01 17:46:05 "bytes_read": 4005 2025-04-01 17:46:05 } 2025-04-01 17:46:05 } 2025-04-01 17:46:05 Bloom filter for ipv4 column. BF is off 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "data": [ 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "json": "{\"key\":38, \"value\":\"NXONM\"}" 2025-04-01 17:46:05 } 2025-04-01 17:46:05 ], 2025-04-01 17:46:05 "rows": 1, 2025-04-01 17:46:05 "statistics": { 2025-04-01 17:46:05 "rows_read": 1000, 2025-04-01 17:46:05 "bytes_read": 47419 2025-04-01 17:46:05 } 2025-04-01 17:46:05 } 2025-04-01 17:46:05 Bloom filter for ipv4 column. BF is on 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "data": [ 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "json": "{\"key\":38, \"value\":\"NXONM\"}" 2025-04-01 17:46:05 } 2025-04-01 17:46:05 ], 2025-04-01 17:46:05 "rows": 1, 2025-04-01 17:46:05 "statistics": { 2025-04-01 17:46:05 "rows_read": 72, 2025-04-01 17:46:05 "bytes_read": 4005 2025-04-01 17:46:05 } 2025-04-01 17:46:05 } 2025-04-01 17:46:05 Bloom filter for ipv4 column. BF is on. Specified in the schema 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "data": [ 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "ipv4": "0.0.1.143" 2025-04-01 17:46:05 } 2025-04-01 17:46:05 ], 2025-04-01 17:46:05 "rows": 1, 2025-04-01 17:46:05 "statistics": { 2025-04-01 17:46:05 "rows_read": 72, 2025-04-01 17:46:05 "bytes_read": 4005 2025-04-01 17:46:05 } 2025-04-01 17:46:05 } 2025-04-01 17:46:05 Bloom filter on 64 bit column read as ipv4. We explicitly deny it, should read all rg 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "data": [ 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "uint64_logical": "22.230.220.164" 2025-04-01 17:46:05 } 2025-04-01 17:46:05 ], 2025-04-01 17:46:05 "rows": 1, 2025-04-01 17:46:05 "statistics": { 2025-04-01 17:46:05 "rows_read": 1000, 2025-04-01 17:46:05 "bytes_read": 47419 2025-04-01 17:46:05 } 2025-04-01 17:46:05 } 2025-04-01 17:46:05 BF off for parquet uint64 logical type. Should read everything 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "data": [ 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "json": "{\"key\":683, \"value\":\"YKCPD\"}" 2025-04-01 17:46:05 } 2025-04-01 17:46:05 ], 2025-04-01 17:46:05 "rows": 1, 2025-04-01 17:46:05 "statistics": { 2025-04-01 17:46:05 "rows_read": 1000, 2025-04-01 17:46:05 "bytes_read": 47419 2025-04-01 17:46:05 } 2025-04-01 17:46:05 } 2025-04-01 17:46:05 BF on for parquet uint64 logical type. Uint64 is stored as a signed int 64, but with logical annotation. Make sure a value greater than int64 can be queried 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "data": [ 2025-04-01 17:46:05 { 2025-04-01 17:46:05 "json": "{\"key\":683, \"value\":\"YKCPD\"}" 2025-04-01 17:46:05 } 2025-04-01 17:46:05 ], 2025-04-01 17:46:05 "rows": 1, 2025-04-01 17:46:05 "statistics": { 2025-04-01 17:46:05 "rows_read": 464, 2025-04-01 17:46:05 "bytes_read": 21711 2025-04-01 17:46:05 } 2025-04-01 17:46:05 } 2025-04-01 17:46:05 Uint16 is stored as physical type int32 with bidwidth = 16 and sign = false. Make sure a value greater than int16 can be queried. BF is on. 2025-04-01 17:46:05 BF off for parquet int8 logical type. Should read everything 2025-04-01 17:46:05 BF on for parquet int8 logical type. Should skip row groups 2025-04-01 17:46:05 Invalid column conversion with in operation. String type can not be hashed against parquet int64 physical type. Should read everything 2025-04-01 17:46:05 Transformations on key column shall not be allowed. Should read everything 2025-04-01 17:46:05 2025-04-01 17:46:05 Settings used in the test: --max_insert_threads 1 --group_by_two_level_threshold 176251 --group_by_two_level_threshold_bytes 50000000 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 6090155 --max_read_buffer_size 661397 --prefer_localhost_replica 0 --max_block_size 37458 --max_joined_block_size_rows 59705 --max_threads 1 --optimize_append_index 0 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 0 --optimize_or_like_chain 1 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 36 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 777581 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 8378955596 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method read --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 2 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 0 --remote_filesystem_read_prefetch 1 --allow_prefetched_read_pool_for_remote_filesystem 1 --filesystem_prefetch_max_memory_usage 128Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 8Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 100Mi --compile_aggregate_expressions 1 --compile_sort_description 1 --merge_tree_coarse_index_granularity 19 --optimize_distinct_in_order 1 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 433165382 --min_compress_block_size 1014462 --max_compress_block_size 1822062 --merge_tree_compact_parts_min_granules_to_multibuffer_read 39 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 2615188 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 3 --session_timezone Mexico/BajaSur --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.67 --prefer_external_sort_block_bytes 1 --cross_join_min_rows_to_compress 1 --cross_join_min_bytes_to_compress 0 --min_external_table_block_size_bytes 0 --max_parsing_threads 1 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 1 --query_plan_join_swap_table false --output_format_native_write_json_as_string 1 --enable_vertical_final 0 2025-04-01 17:46:05 2025-04-01 17:46:05 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 10737418240 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 100 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 10737418240 --index_granularity_bytes 670404 --merge_max_block_size 7911 --index_granularity 39340 --min_bytes_for_wide_part 0 --marks_compress_block_size 81766 --primary_key_compress_block_size 8481 --replace_long_file_name_to_hash 1 --max_file_name_length 119 --min_bytes_for_full_part_storage 536870912 --compact_parts_max_bytes_to_buffer 261665137 --compact_parts_max_granules_to_buffer 204 --compact_parts_merge_max_bytes_to_prefetch_part 14650012 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 41 --old_parts_lifetime 213 --prewarm_mark_cache 1 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 0 --use_primary_key_cache 1 --prewarm_primary_key_cache 0 2025-04-01 17:46:05 2025-04-01 17:46:05 Database: test_jypz7w9c 2025-04-01 17:46:07 02317_distinct_in_order_optimization_explain: [ FAIL ] 29.27 sec. 2025-04-01 17:46:07 Reason: return code: 210 2025-04-01 17:46:07 Code: 210. DB::NetException: Connection reset by peer, while reading from socket (peer: [::1]:9000, local: [::1]:58594): (localhost:9000, ::1, local address: [::1]:58594). (NETWORK_ERROR) 2025-04-01 17:46:07 2025-04-01 17:46:07 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-01 17:46:07 2025-04-01 17:46:07 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-01 17:46:07 2025-04-01 17:46:07 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-01 17:46:07 2025-04-01 17:46:07 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-01 17:46:07 2025-04-01 17:46:07 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-01 17:46:07 2025-04-01 17:46:07 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-01 17:46:07 2025-04-01 17:46:07 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-01 17:46:07 2025-04-01 17:46:07 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-01 17:46:07 2025-04-01 17:46:07 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-01 17:46:07 2025-04-01 17:46:07 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-01 17:46:07 2025-04-01 17:46:07 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-01 17:46:07 2025-04-01 17:46:07 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-01 17:46:07 2025-04-01 17:46:07 , result: 2025-04-01 17:46:07 2025-04-01 17:46:07 -- disable optimize_distinct_in_order 2025-04-01 17:46:07 -- distinct all primary key columns -> ordinary distinct 2025-04-01 17:46:07 DistinctTransform 2025-04-01 17:46:07 DistinctTransform 2025-04-01 17:46:07 -- enable optimize_distinct_in_order 2025-04-01 17:46:07 -- distinct with all primary key columns -> pre-distinct optimization only 2025-04-01 17:46:07 DistinctTransform 2025-04-01 17:46:07 DistinctSortedStreamTransform 2025-04-01 17:46:07 -- distinct with primary key prefix -> pre-distinct optimization only 2025-04-01 17:46:07 DistinctTransform 2025-04-01 17:46:07 DistinctSortedStreamTransform 2025-04-01 17:46:07 -- distinct with primary key prefix and order by column in distinct -> pre-distinct and final distinct optimization 2025-04-01 17:46:07 DistinctSortedTransform 2025-04-01 17:46:07 DistinctSortedStreamTransform 2025-04-01 17:46:07 -- distinct with primary key prefix and order by the same columns -> pre-distinct and final distinct optimization 2025-04-01 17:46:07 DistinctSortedStreamTransform 2025-04-01 17:46:07 DistinctSortedStreamTransform 2025-04-01 17:46:07 -- distinct with primary key prefix and order by columns are prefix of distinct columns -> pre-distinct and final distinct optimization 2025-04-01 17:46:07 DistinctSortedTransform 2025-04-01 17:46:07 DistinctSortedStreamTransform 2025-04-01 17:46:07 -- distinct with primary key prefix and order by column in distinct but non-primary key prefix -> pre-distinct and final distinct optimization 2025-04-01 17:46:07 DistinctSortedTransform 2025-04-01 17:46:07 DistinctSortedStreamTransform 2025-04-01 17:46:07 -- distinct with primary key prefix and order by column _not_ in distinct -> pre-distinct optimization only 2025-04-01 17:46:07 DistinctTransform 2025-04-01 17:46:07 DistinctSortedStreamTransform 2025-04-01 17:46:07 -- distinct with non-primary key prefix -> ordinary distinct 2025-04-01 17:46:07 DistinctTransform 2025-04-01 17:46:07 DistinctTransform 2025-04-01 17:46:07 -- distinct with non-primary key prefix and order by column in distinct -> final distinct optimization only 2025-04-01 17:46:07 DistinctSortedTransform 2025-04-01 17:46:07 DistinctTransform 2025-04-01 17:46:07 -- distinct with non-primary key prefix and order by column _not_ in distinct -> ordinary distinct 2025-04-01 17:46:07 DistinctTransform 2025-04-01 17:46:07 DistinctTransform 2025-04-01 17:46:07 -- distinct with non-primary key prefix and order by _const_ column in distinct -> ordinary distinct 2025-04-01 17:46:07 DistinctTransform 2025-04-01 17:46:07 DistinctTransform 2025-04-01 17:46:07 -- Check reading in order for distinct 2025-04-01 17:46:07 -- disabled, distinct columns match sorting key 2025-04-01 17:46:07 algorithm: Thread 2025-04-01 17:46:07 -- enabled, distinct columns match sorting key 2025-04-01 17:46:07 algorithm: InOrder 2025-04-01 17:46:07 -- enabled, distinct columns form prefix of sorting key 2025-04-01 17:46:07 algorithm: InOrder 2025-04-01 17:46:07 -- enabled, distinct columns DON't form prefix of sorting key 2025-04-01 17:46:07 algorithm: Thread 2025-04-01 17:46:07 -- enabled, distinct columns contains constant columns, non-const columns form prefix of sorting key 2025-04-01 17:46:07 algorithm: InOrder 2025-04-01 17:46:07 -- enabled, distinct columns contains constant columns, non-const columns match prefix of sorting key 2025-04-01 17:46:07 algorithm: InOrder 2025-04-01 17:46:07 -- enabled, only part of distinct columns form prefix of sorting key 2025-04-01 17:46:07 algorithm: InOrder 2025-04-01 17:46:07 === disable new analyzer === 2025-04-01 17:46:07 -- enabled, check that sorting properties are propagated from ReadFromMergeTree till preliminary distinct 2025-04-01 17:46:07 Sorting: a ASC, b ASC 2025-04-01 17:46:07 Sorting: a ASC, b ASC 2025-04-01 17:46:07 -- check that reading in order optimization for ORDER BY and DISTINCT applied correctly in the same query 2025-04-01 17:46:07 -- disabled, check that sorting description for ReadFromMergeTree match ORDER BY columns 2025-04-01 17:46:07 Sorting: a ASC 2025-04-01 17:46:07 Sorting: a ASC 2025-04-01 17:46:07 -- enabled, check that ReadFromMergeTree sorting description is overwritten by DISTINCT optimization i.e. it contains columns from DISTINCT clause 2025-04-01 17:46:07 -- enabled, check that ReadFromMergeTree sorting description is overwritten by DISTINCT optimization, but direction used from ORDER BY clause 2025-04-01 17:46:07 -- enabled, check that ReadFromMergeTree sorting description is NOT overwritten by DISTINCT optimization (1), - it contains columns from ORDER BY clause 2025-04-01 17:46:07 -- enabled, check that ReadFromMergeTree sorting description is NOT overwritten by DISTINCT optimization (2), - direction used from ORDER BY clause 2025-04-01 17:46:07 -- enabled, check that disabling other 'read in order' optimizations do not disable distinct in order optimization 2025-04-01 17:46:07 === enable new analyzer === 2025-04-01 17:46:07 -- enabled, check that sorting properties are propagated from ReadFromMergeTree till preliminary distinct 2025-04-01 17:46:07 -- disabled, check that sorting description for ReadFromMergeTree match ORDER BY columns 2025-04-01 17:46:07 -- enabled, check that ReadFromMergeTree sorting description is overwritten by DISTINCT optimization i.e. it contains columns from DISTINCT clause 2025-04-01 17:46:07 -- enabled, check that ReadFromMergeTree sorting description is overwritten by DISTINCT optimization, but direction used from ORDER BY clause 2025-04-01 17:46:07 -- enabled, check that ReadFromMergeTree sorting description is NOT overwritten by DISTINCT optimization (1), - it contains columns from ORDER BY clause 2025-04-01 17:46:07 -- enabled, check that ReadFromMergeTree sorting description is NOT overwritten by DISTINCT optimization (2), - direction used from ORDER BY clause 2025-04-01 17:46:07 -- enabled, check that disabling other 'read in order' optimizations do not disable distinct in order optimization 2025-04-01 17:46:07 2025-04-01 17:46:07 stdout: 2025-04-01 17:46:07 -- disable optimize_distinct_in_order 2025-04-01 17:46:07 -- distinct all primary key columns -> ordinary distinct 2025-04-01 17:46:07 DistinctTransform 2025-04-01 17:46:07 DistinctTransform 2025-04-01 17:46:07 -- enable optimize_distinct_in_order 2025-04-01 17:46:07 -- distinct with all primary key columns -> pre-distinct optimization only 2025-04-01 17:46:07 DistinctTransform 2025-04-01 17:46:07 DistinctSortedStreamTransform 2025-04-01 17:46:07 -- distinct with primary key prefix -> pre-distinct optimization only 2025-04-01 17:46:07 DistinctTransform 2025-04-01 17:46:07 DistinctSortedStreamTransform 2025-04-01 17:46:07 -- distinct with primary key prefix and order by column in distinct -> pre-distinct and final distinct optimization 2025-04-01 17:46:07 DistinctSortedTransform 2025-04-01 17:46:07 DistinctSortedStreamTransform 2025-04-01 17:46:07 -- distinct with primary key prefix and order by the same columns -> pre-distinct and final distinct optimization 2025-04-01 17:46:07 DistinctSortedStreamTransform 2025-04-01 17:46:07 DistinctSortedStreamTransform 2025-04-01 17:46:07 -- distinct with primary key prefix and order by columns are prefix of distinct columns -> pre-distinct and final distinct optimization 2025-04-01 17:46:07 DistinctSortedTransform 2025-04-01 17:46:07 DistinctSortedStreamTransform 2025-04-01 17:46:07 -- distinct with primary key prefix and order by column in distinct but non-primary key prefix -> pre-distinct and final distinct optimization 2025-04-01 17:46:07 DistinctSortedTransform 2025-04-01 17:46:07 DistinctSortedStreamTransform 2025-04-01 17:46:07 -- distinct with primary key prefix and order by column _not_ in distinct -> pre-distinct optimization only 2025-04-01 17:46:07 DistinctTransform 2025-04-01 17:46:07 DistinctSortedStreamTransform 2025-04-01 17:46:07 -- distinct with non-primary key prefix -> ordinary distinct 2025-04-01 17:46:07 DistinctTransform 2025-04-01 17:46:07 DistinctTransform 2025-04-01 17:46:07 -- distinct with non-primary key prefix and order by column in distinct -> final distinct optimization only 2025-04-01 17:46:07 DistinctSortedTransform 2025-04-01 17:46:07 DistinctTransform 2025-04-01 17:46:07 -- distinct with non-primary key prefix and order by column _not_ in distinct -> ordinary distinct 2025-04-01 17:46:07 DistinctTransform 2025-04-01 17:46:07 DistinctTransform 2025-04-01 17:46:07 -- distinct with non-primary key prefix and order by _const_ column in distinct -> ordinary distinct 2025-04-01 17:46:07 DistinctTransform 2025-04-01 17:46:07 DistinctTransform 2025-04-01 17:46:07 -- Check reading in order for distinct 2025-04-01 17:46:07 -- disabled, distinct columns match sorting key 2025-04-01 17:46:07 algorithm: Thread 2025-04-01 17:46:07 -- enabled, distinct columns match sorting key 2025-04-01 17:46:07 algorithm: InOrder 2025-04-01 17:46:07 -- enabled, distinct columns form prefix of sorting key 2025-04-01 17:46:07 algorithm: InOrder 2025-04-01 17:46:07 -- enabled, distinct columns DON't form prefix of sorting key 2025-04-01 17:46:07 algorithm: Thread 2025-04-01 17:46:07 -- enabled, distinct columns contains constant columns, non-const columns form prefix of sorting key 2025-04-01 17:46:07 algorithm: InOrder 2025-04-01 17:46:07 -- enabled, distinct columns contains constant columns, non-const columns match prefix of sorting key 2025-04-01 17:46:07 algorithm: InOrder 2025-04-01 17:46:07 -- enabled, only part of distinct columns form prefix of sorting key 2025-04-01 17:46:07 algorithm: InOrder 2025-04-01 17:46:07 === disable new analyzer === 2025-04-01 17:46:07 -- enabled, check that sorting properties are propagated from ReadFromMergeTree till preliminary distinct 2025-04-01 17:46:07 Sorting: a ASC, b ASC 2025-04-01 17:46:07 Sorting: a ASC, b ASC 2025-04-01 17:46:07 -- check that reading in order optimization for ORDER BY and DISTINCT applied correctly in the same query 2025-04-01 17:46:07 -- disabled, check that sorting description for ReadFromMergeTree match ORDER BY columns 2025-04-01 17:46:07 Sorting: a ASC 2025-04-01 17:46:07 Sorting: a ASC 2025-04-01 17:46:07 -- enabled, check that ReadFromMergeTree sorting description is overwritten by DISTINCT optimization i.e. it contains columns from DISTINCT clause 2025-04-01 17:46:07 -- enabled, check that ReadFromMergeTree sorting description is overwritten by DISTINCT optimization, but direction used from ORDER BY clause 2025-04-01 17:46:07 -- enabled, check that ReadFromMergeTree sorting description is NOT overwritten by DISTINCT optimization (1), - it contains columns from ORDER BY clause 2025-04-01 17:46:07 -- enabled, check that ReadFromMergeTree sorting description is NOT overwritten by DISTINCT optimization (2), - direction used from ORDER BY clause 2025-04-01 17:46:07 -- enabled, check that disabling other 'read in order' optimizations do not disable distinct in order optimization 2025-04-01 17:46:07 === enable new analyzer === 2025-04-01 17:46:07 -- enabled, check that sorting properties are propagated from ReadFromMergeTree till preliminary distinct 2025-04-01 17:46:07 -- disabled, check that sorting description for ReadFromMergeTree match ORDER BY columns 2025-04-01 17:46:07 -- enabled, check that ReadFromMergeTree sorting description is overwritten by DISTINCT optimization i.e. it contains columns from DISTINCT clause 2025-04-01 17:46:07 -- enabled, check that ReadFromMergeTree sorting description is overwritten by DISTINCT optimization, but direction used from ORDER BY clause 2025-04-01 17:46:07 -- enabled, check that ReadFromMergeTree sorting description is NOT overwritten by DISTINCT optimization (1), - it contains columns from ORDER BY clause 2025-04-01 17:46:07 -- enabled, check that ReadFromMergeTree sorting description is NOT overwritten by DISTINCT optimization (2), - direction used from ORDER BY clause 2025-04-01 17:46:07 -- enabled, check that disabling other 'read in order' optimizations do not disable distinct in order optimization 2025-04-01 17:46:07 2025-04-01 17:46:07 2025-04-01 17:46:07 Settings used in the test: --max_insert_threads 2 --group_by_two_level_threshold 786045 --group_by_two_level_threshold_bytes 50000000 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 4698335 --max_read_buffer_size 789110 --prefer_localhost_replica 0 --max_block_size 86889 --max_joined_block_size_rows 67122 --max_threads 3 --optimize_append_index 1 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 0 --optimize_or_like_chain 0 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 56 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 29243934 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 9709034220 --min_bytes_to_use_mmap_io 3483143077 --local_filesystem_read_method pread --remote_filesystem_read_method read --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 2 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 0 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 1 --filesystem_prefetch_max_memory_usage 32Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 0 --compile_sort_description 0 --merge_tree_coarse_index_granularity 22 --optimize_distinct_in_order 1 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 10711791914 --max_bytes_before_remerge_sort 1724396297 --min_compress_block_size 509181 --max_compress_block_size 961470 --merge_tree_compact_parts_min_granules_to_multibuffer_read 113 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 10285867 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 3 --session_timezone Mexico/BajaSur --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.89 --prefer_external_sort_block_bytes 1 --cross_join_min_rows_to_compress 1 --cross_join_min_bytes_to_compress 1 --min_external_table_block_size_bytes 100000000 --max_parsing_threads 0 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 1 --query_plan_join_swap_table auto --output_format_native_write_json_as_string 1 --enable_vertical_final 1 2025-04-01 17:46:07 2025-04-01 17:46:07 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 0.7563738772706338 --prefer_fetch_merged_part_size_threshold 2012106554 --vertical_merge_algorithm_min_rows_to_activate 1 --vertical_merge_algorithm_min_columns_to_activate 82 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 10737418240 --index_granularity_bytes 27699374 --merge_max_block_size 19581 --index_granularity 48176 --min_bytes_for_wide_part 0 --marks_compress_block_size 17345 --primary_key_compress_block_size 29004 --replace_long_file_name_to_hash 1 --max_file_name_length 0 --min_bytes_for_full_part_storage 0 --compact_parts_max_bytes_to_buffer 126996618 --compact_parts_max_granules_to_buffer 256 --compact_parts_merge_max_bytes_to_prefetch_part 22889841 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 100 --old_parts_lifetime 480 --prewarm_mark_cache 1 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 0 --use_primary_key_cache 1 --prewarm_primary_key_cache 0 2025-04-01 17:46:07 2025-04-01 17:46:07 Database: test_l0nrtmbt 2025-04-01 17:46:13 02122_parallel_formatting_RowBinaryWithNames: [ FAIL ] 0.00 sec. 2025-04-01 17:46:13 Reason: server died 2025-04-01 17:46:13 Server does not respond to health check 2025-04-01 17:46:13 2025-04-01 17:46:13 01440_big_int_exotic_casts: [ FAIL ] 0.00 sec. 2025-04-01 17:46:13 Reason: server died 2025-04-01 17:46:13 Server does not respond to health check 2025-04-01 17:46:13 2025-04-01 17:46:13 Process Process-6: 2025-04-01 17:46:13 Traceback (most recent call last): 2025-04-01 17:46:13 File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap 2025-04-01 17:46:13 self.run() 2025-04-01 17:46:13 File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run 2025-04-01 17:46:13 self._target(*self._args, **self._kwargs) 2025-04-01 17:46:13 File "/usr/bin/clickhouse-test", line 2626, in run_tests_process 2025-04-01 17:46:13 return run_tests_array(*args, **kwargs) 2025-04-01 17:46:13 File "/usr/bin/clickhouse-test", line 2407, in run_tests_array 2025-04-01 17:46:13 stop_tests() 2025-04-01 17:46:13 File "/usr/bin/clickhouse-test", line 452, in stop_tests 2025-04-01 17:46:13 cleanup_child_processes(os.getpid()) 2025-04-01 17:46:13 File "/usr/bin/clickhouse-test", line 440, in cleanup_child_processes 2025-04-01 17:46:13 child_pgid = os.getpgid(child) 2025-04-01 17:46:13 ProcessLookupError: [Errno 3] No such process 2025-04-01 17:46:13 Child processes of 1388: 2025-04-01 17:46:13 41795 /bin/sh -c pgrep --parent 1388 -a 2025-04-01 17:46:13 Process Process-4: 2025-04-01 17:46:13 Traceback (most recent call last): 2025-04-01 17:46:13 File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap 2025-04-01 17:46:13 self.run() 2025-04-01 17:46:13 File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run 2025-04-01 17:46:13 self._target(*self._args, **self._kwargs) 2025-04-01 17:46:13 File "/usr/bin/clickhouse-test", line 2626, in run_tests_process 2025-04-01 17:46:13 return run_tests_array(*args, **kwargs) 2025-04-01 17:46:13 File "/usr/bin/clickhouse-test", line 2407, in run_tests_array 2025-04-01 17:46:13 stop_tests() 2025-04-01 17:46:13 File "/usr/bin/clickhouse-test", line 452, in stop_tests 2025-04-01 17:46:13 cleanup_child_processes(os.getpid()) 2025-04-01 17:46:13 File "/usr/bin/clickhouse-test", line 440, in cleanup_child_processes 2025-04-01 17:46:13 child_pgid = os.getpgid(child) 2025-04-01 17:46:13 ProcessLookupError: [Errno 3] No such process 2025-04-01 17:46:13 Child processes of 1384: 2025-04-01 17:46:13 41797 /bin/sh -c pgrep --parent 1384 -a 2025-04-01 17:46:13 02221_parallel_replicas_bug: [ FAIL ] 0.00 sec. 2025-04-01 17:46:13 Reason: server died 2025-04-01 17:46:13 Server does not respond to health check 2025-04-01 17:46:13 2025-04-01 17:46:13 Database: test_sczjo540 2025-04-01 17:46:13 Process Process-5: 2025-04-01 17:46:13 Traceback (most recent call last): 2025-04-01 17:46:13 File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap 2025-04-01 17:46:13 self.run() 2025-04-01 17:46:13 File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run 2025-04-01 17:46:13 self._target(*self._args, **self._kwargs) 2025-04-01 17:46:13 File "/usr/bin/clickhouse-test", line 2626, in run_tests_process 2025-04-01 17:46:13 return run_tests_array(*args, **kwargs) 2025-04-01 17:46:13 File "/usr/bin/clickhouse-test", line 2407, in run_tests_array 2025-04-01 17:46:13 stop_tests() 2025-04-01 17:46:13 File "/usr/bin/clickhouse-test", line 452, in stop_tests 2025-04-01 17:46:13 cleanup_child_processes(os.getpid()) 2025-04-01 17:46:13 File "/usr/bin/clickhouse-test", line 440, in cleanup_child_processes 2025-04-01 17:46:13 child_pgid = os.getpgid(child) 2025-04-01 17:46:13 ProcessLookupError: [Errno 3] No such process 2025-04-01 17:46:13 Child processes of 1385: 2025-04-01 17:46:13 41807 /bin/sh -c pgrep --parent 1385 -a 2025-04-01 17:46:14 01901_in_literal_shard_prune: [ FAIL ] 0.00 sec. 2025-04-01 17:46:14 Reason: server died 2025-04-01 17:46:14 Server does not respond to health check 2025-04-01 17:46:14 2025-04-01 17:46:14 Process Process-8: 2025-04-01 17:46:14 Traceback (most recent call last): 2025-04-01 17:46:14 File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap 2025-04-01 17:46:14 self.run() 2025-04-01 17:46:14 File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run 2025-04-01 17:46:14 self._target(*self._args, **self._kwargs) 2025-04-01 17:46:14 File "/usr/bin/clickhouse-test", line 2626, in run_tests_process 2025-04-01 17:46:14 return run_tests_array(*args, **kwargs) 2025-04-01 17:46:14 File "/usr/bin/clickhouse-test", line 2407, in run_tests_array 2025-04-01 17:46:14 stop_tests() 2025-04-01 17:46:14 File "/usr/bin/clickhouse-test", line 452, in stop_tests 2025-04-01 17:46:14 cleanup_child_processes(os.getpid()) 2025-04-01 17:46:14 File "/usr/bin/clickhouse-test", line 440, in cleanup_child_processes 2025-04-01 17:46:14 child_pgid = os.getpgid(child) 2025-04-01 17:46:14 ProcessLookupError: [Errno 3] No such process 2025-04-01 17:46:14 Child processes of 1391: 2025-04-01 17:46:14 41813 /bin/sh -c pgrep --parent 1391 -a 2025-04-01 17:46:14 02565_update_empty_nested: [ FAIL ] 0.00 sec. 2025-04-01 17:46:14 Reason: server died 2025-04-01 17:46:14 Server does not respond to health check 2025-04-01 17:46:14 2025-04-01 17:46:14 Process Process-7: 2025-04-01 17:46:14 Traceback (most recent call last): 2025-04-01 17:46:14 File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap 2025-04-01 17:46:14 self.run() 2025-04-01 17:46:14 File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run 2025-04-01 17:46:14 self._target(*self._args, **self._kwargs) 2025-04-01 17:46:14 File "/usr/bin/clickhouse-test", line 2626, in run_tests_process 2025-04-01 17:46:14 return run_tests_array(*args, **kwargs) 2025-04-01 17:46:14 File "/usr/bin/clickhouse-test", line 2407, in run_tests_array 2025-04-01 17:46:14 stop_tests() 2025-04-01 17:46:14 File "/usr/bin/clickhouse-test", line 452, in stop_tests 2025-04-01 17:46:14 cleanup_child_processes(os.getpid()) 2025-04-01 17:46:14 File "/usr/bin/clickhouse-test", line 440, in cleanup_child_processes 2025-04-01 17:46:14 child_pgid = os.getpgid(child) 2025-04-01 17:46:14 ProcessLookupError: [Errno 3] No such process 2025-04-01 17:46:14 Child processes of 1390: 2025-04-01 17:46:14 41819 /bin/sh -c pgrep --parent 1390 -a 2025-04-01 17:46:15 01115_prewhere_array_join: [ FAIL ] 0.00 sec. 2025-04-01 17:46:15 Reason: server died 2025-04-01 17:46:15 Server does not respond to health check 2025-04-01 17:46:15 2025-04-01 17:46:15 Process Process-3: 2025-04-01 17:46:15 Traceback (most recent call last): 2025-04-01 17:46:15 File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap 2025-04-01 17:46:15 self.run() 2025-04-01 17:46:15 File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run 2025-04-01 17:46:15 self._target(*self._args, **self._kwargs) 2025-04-01 17:46:15 File "/usr/bin/clickhouse-test", line 2626, in run_tests_process 2025-04-01 17:46:15 return run_tests_array(*args, **kwargs) 2025-04-01 17:46:15 File "/usr/bin/clickhouse-test", line 2407, in run_tests_array 2025-04-01 17:46:15 stop_tests() 2025-04-01 17:46:15 File "/usr/bin/clickhouse-test", line 452, in stop_tests 2025-04-01 17:46:15 cleanup_child_processes(os.getpid()) 2025-04-01 17:46:15 File "/usr/bin/clickhouse-test", line 440, in cleanup_child_processes 2025-04-01 17:46:15 child_pgid = os.getpgid(child) 2025-04-01 17:46:15 ProcessLookupError: [Errno 3] No such process 2025-04-01 17:46:15 Child processes of 1383: 2025-04-01 17:46:15 41825 /bin/sh -c pgrep --parent 1383 -a 2025-04-01 17:46:17 01047_no_alias_columns_with_table_aliases: [ FAIL ] 0.00 sec. 2025-04-01 17:46:17 Reason: server died 2025-04-01 17:46:17 Server does not respond to health check 2025-04-01 17:46:17 2025-04-01 17:46:17 Process Process-10: 2025-04-01 17:46:17 Traceback (most recent call last): 2025-04-01 17:46:17 File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap 2025-04-01 17:46:17 self.run() 2025-04-01 17:46:17 File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run 2025-04-01 17:46:17 self._target(*self._args, **self._kwargs) 2025-04-01 17:46:17 File "/usr/bin/clickhouse-test", line 2626, in run_tests_process 2025-04-01 17:46:17 return run_tests_array(*args, **kwargs) 2025-04-01 17:46:17 File "/usr/bin/clickhouse-test", line 2407, in run_tests_array 2025-04-01 17:46:17 stop_tests() 2025-04-01 17:46:17 File "/usr/bin/clickhouse-test", line 452, in stop_tests 2025-04-01 17:46:17 cleanup_child_processes(os.getpid()) 2025-04-01 17:46:17 File "/usr/bin/clickhouse-test", line 440, in cleanup_child_processes 2025-04-01 17:46:17 child_pgid = os.getpgid(child) 2025-04-01 17:46:17 ProcessLookupError: [Errno 3] No such process 2025-04-01 17:46:17 Child processes of 1397: 2025-04-01 17:46:17 41831 /bin/sh -c pgrep --parent 1397 -a 2025-04-01 17:59:04 Hung check failed: [Errno 111] Connection refused 2025-04-01 17:59:04 Server died, terminating all processes... 2025-04-01 17:59:04 Running 130 stateless tests (MainProcess). 2025-04-01 17:59:04 Child processes of 1367: 2025-04-01 17:59:04 1370 python3 /usr/bin/clickhouse-test --testname --shard --zookeeper --check-zookeeper-session --hung-check --print-time --no-drop-if-fail --capture-client-stacktrace --queries /repo/tests/queries --test-runs 1 --hung-check --print-time --jobs 8 --run-by-hash-num 2 --run-by-hash-total 4 --report-logs-stats 2025-04-01 17:59:04 1376 python3 /usr/bin/clickhouse-test --testname --shard --zookeeper --check-zookeeper-session --hung-check --print-time --no-drop-if-fail --capture-client-stacktrace --queries /repo/tests/queries --test-runs 1 --hung-check --print-time --jobs 8 --run-by-hash-num 2 --run-by-hash-total 4 --report-logs-stats 2025-04-01 17:59:04 41839 /bin/sh -c pgrep --parent 1367 -a 2025-04-01 17:59:04 Traceback (most recent call last): 2025-04-01 17:59:04 File "/usr/bin/clickhouse-test", line 3716, in 2025-04-01 17:59:04 main(args) 2025-04-01 17:59:04 File "/usr/bin/clickhouse-test", line 3063, in main 2025-04-01 17:59:04 total_tests_run += do_run_tests(args.jobs, test_suite) 2025-04-01 17:59:04 File "/usr/bin/clickhouse-test", line 2697, in do_run_tests 2025-04-01 17:59:04 run_tests_array( 2025-04-01 17:59:04 File "/usr/bin/clickhouse-test", line 2343, in run_tests_array 2025-04-01 17:59:04 stop_tests() 2025-04-01 17:59:04 File "/usr/bin/clickhouse-test", line 452, in stop_tests 2025-04-01 17:59:04 cleanup_child_processes(os.getpid()) 2025-04-01 17:59:04 File "/usr/bin/clickhouse-test", line 440, in cleanup_child_processes 2025-04-01 17:59:04 child_pgid = os.getpgid(child) 2025-04-01 17:59:04 ProcessLookupError: [Errno 3] No such process